The solution is to use something closer to a compile-time SQL or DSL, such as jO...

echelon on Sept 20, 2019 | parent | context | favorite | on: What ORMs have taught me: just learn SQL (2014)

The solution is to use something closer to a compile-time SQL or DSL, such as jOOQ or SqlAlchemy (sans the ORM pieces). These are terrific technologies that improve upon SQLs weaknesses and achieve some level of portability.