> To be honest I'm not entirely sold that these DSLs are what I'd consider "strongly typed." Absolutely! They're "quite" typesafe, much more than string-based

> To be honest I'm not entirely sold that these DSLs are what I'd consider "strongly typed." Absolutely! They're "quite" typesafe, much more than string-based SQL. Much less than actual compiled stored procedures. > As an example: jOOq will happily let you write an update query targeting a table bound to an alias. Yes, that currently cannot be detected. > Then there's the issue of the dialects letting you use features the RDBMS doesn't support That will be addressed in the near future when we implement an API "preprocessor" that will effectively remove all parts of the API that are not supported by your given dialect. We'll also distinguish between native support and emulated support, if this strictness matters in your application. The relevant issue is here: https://github.com/jOOQ/jOOQ/issues/720 https://github.com/jOOQ/jOOQ/issues/720 > In practice I've just never seen that to be true. True, but if you need "write once, run anywhere", you're probably much better off with a headstart than if you started from scratch.