Re:I don't want to learn your query language (2018)
by alexvoda on Wednesday March 10, 2021 @06:12PM
(#26417760)
Also, all languages I used support parametrized queries so you do not have to mix data and query strings. Not converting data to strings is not an argument for ORMs, it's an argument for parametrized queries.
People should really look into JOOQ to see what a SQL friendly ORM looks like.
Re:I don't want to learn your query language (2018)
by geocar on Thursday March 11, 2021 @03:39AM
(#26421719)
> Also, all languages I used support parametrized queries so you do not have to mix data and query strings. Not converting data to strings is not an argument for ORMs, it's an argument for parametrized queries.
Your "parameterized" queries are still serialized strings. Many language bindings for SQL interfaces don't have good support for serializing data types, so you will often see things like ?::datetime in the template string. Some don't have the ability to parameterize column names (or have subtle bugs) either.
> People should really look into JOOQ to see what a SQL friendly ORM looks like.
I've never heard of JOOQ. Do you know of a good introduction?
Re:I don't want to learn your query language (2018)
by lukaseder on Sunday March 14, 2021 @05:50AM
(#26453966)
> Your "parameterized" queries are still serialized strings. Many language bindings for SQL interfaces don't have good support for serializing data types, so you will often see things like ?::datetime in the template string.
How else would you do it, short of a binary query format?
Structured types are in SQL since 1999.