3 ms·
You really want something that lets you write table=db.table("table1") table.insert({"col1": val1, "col2": val2}) at the very least, if you are really wr
by PaulHoule 1y ago
You really want something that lets you write
table=db.table("table1")
table.insert({"col1": val1, "col2": val2})
at the very least, if you are really writing lots of INSERTs by hand I bet you are either not quoting properly or you are writing queries with 15 placeholders and someday you'll put one in the wrong place.
ORMs and related toolkits have come a long way since they were called the "Vietnam of Computer Science". I am a big fan of JooQ in Java
https://www.jooq.org/ https://www.jooq.org/
and SQLAlchemy in Python
https://www.sqlalchemy.org/ https://www.sqlalchemy.org/
Note both of these support both an object <-> SQL mapper (usually with generated objects) that covers the case of my code sample above, and a DSL for SQL inside the host language which is delightful if you want to do code generation to make query builders and stuff like that. I work on a very complex search interface which builds out joins, subqueries, recursive CTEs, you name it, and the code is pretty easy to maintain.