At my workplace, we've started using jOOQ for this sort of thing. https://www.jooq.org/ https://www.jooq.org/ (albeit we're a Java shop, not a C# shop) It stil

At my workplace, we've started using jOOQ for this sort of thing. https://www.jooq.org/ https://www.jooq.org/ (albeit we're a Java shop, not a C# shop) It still sort of generates SQL for you, but really you end up writing the SQL yourself except in a type-safe way.