honeysql

liebs 2023-05-23T17:58:42.887309Z

I'm getting this exception from the SQL Server JDBC driver

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WITH'.
The query itself is a simple CREATE TABLE statement that has no usages of WITH as far as I can see. I used honeysql to generate the query (including the :with-columns syntax) and that's the only thing I can think of that might be a problem here, but I don't see how. (I'm also a SQL noob though.) Insights appreciated.

seancorfield 2023-05-23T18:59:04.214589Z

Show us the HoneySQL calls and what they produce.

seancorfield 2023-05-23T19:00:42.788619Z

There are some examples in the docs which might help you: https://cljdoc.org/d/com.github.seancorfield/honeysql/2.4.1033/doc/getting-started/sql-clause-reference#create-table-with-columns

liebs 2023-05-23T19:15:30.317359Z

Stumbled on my own typo, actually. Thanks!

👍🏻 1