DEV Community

Discussion on: I'm Building an ORM for Deno!

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt • Edited

Cool.

One thing that comes to mind is -- how do build the SQL builder? How do you make identifier always valid? What about protection against SQL injection?

Another thing is JSON querying support. Aren't the syntaxes different across SQL providers?

This was my experience, github.com/patarapolw/liteorm

Collapse
 
rahmanfadhil profile image
Rahman Fadhil

What a nice project!

The query builder is pretty simple at this point, every method in that class returns this, so that you can chain multiple methods like where, first, and select to get the result that you want.

Security is one of my concerns too, but it's a bit challenging. For now, I'm trying to implement the minimum requirement for preventing SQL injection by escaping user inputs on my query builder.

If you know anything to improve security on an ORM, I would love to know!