News for hackers. Stuff that matters.
Re:An Unlikely Database Migration by manigandham on Wednesday January 13, 2021 @10:54PM (#25771737)
Do you have an example of the right tool? SQL is already a DSL and I can't see how creating another language isn't just adding more overhead without actually getting you to usable objects.

The only reason objects are the "wrong" abstraction is because they don't match relational models exactly. That impedance mismatch is the entire reason for the object-to-relational mapping, otherwise you can use things like document-stores and just serialize your objects directly.

Re:An Unlikely Database Migration by nine_k on Wednesday January 13, 2021 @11:46PM (#25772149)
SQLAlchemy gives a nice composable DSL in Python; it has an ORM layer on top of it, too, but it's optional.

JOOQ allows for composable typesafe SQL in Java.

Re:An Unlikely Database Migration by jsumrall on Thursday January 14, 2021 @01:56AM (#25773055)
+1 for jOOQ!