re: I'm Building an ORM for Deno! VIEW POST



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


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!

code of conduct - report abuse