6 ms·

You should check objection.js[1] as I think it would get you what you describe and probably more. It is a relational query builder built on top of knex, which i

You should check objection.js[1] as I think it would get you what you describe and probably more. It is a relational query builder built on top of knex, which is a query builder. [1] https://vincit.github.io/objection.js/ https://vincit.github.io/objection.js/

renke1 6y ago
Thanks, I'll check it out. But on first glance it doesn't seem to let me write actual SQL queries. Also, it doesn't seem to be typesafe, or is it?
- chrischen 6y ago
  It says it has typescript support.
  - renke1 6y ago
    I didn't check those typings, but I don't think the model itself is type safe from the looks of it.
    - mceachen 6y ago
      It is. See my ggp reply.
mceachen 6y ago
I wrote the original typescript bindings for objection. One of the library authors is a contributor to knex.js, which objection uses for query building. Both are quite nice. With either library, you aren't writing naked SQL, but something like `query.where("updated_at", ">", Date.now())`. Tsc comes into play when you send typed objects into your .where, .insert, ... methods and what you get back from the query. It's close enough to SQL that you don't lose expressiveness, you're not behind walls of magick due to orm, and you don't have to worry about Bobby Droptables.