Just checking to see if there's a beefier version of create-table-ddl that people might know about.

clojure.java.jdbc is intended to be completely DB agnostic and DDL is notoriously DB-specific so it's very hard to support "useful" stuff generically. There's a honeysql-postgres library that, together with honeysql, should get you a bit closer.

(also, it's not really clojure.java.jdbc's purpose to generate SQL, just to run it, so the few affordances it provides for that are as generic as possible, and therefore fairly minimal by design)

@dave.tenny ^

Yeah, again I wasn't trying to slight clojure.java.jdbc in this case, I understand the goal.

Just looking for tooling rather than reinvent wheels or take the cruder approach I have for plan B.

regardless I don't think create-table-ddl gets used all that much, the typical approach is to keep ddl in files used by some some migration library

I'm using honeysql for queries, good point it can probably be used for all my ddl too, assuming I don't fall into honeysql/raw traps.

something like https://github.com/yogthos/migratus is the approach to ddl that the clojure projects I've worked on has taken