hugsql

erwinrooijakkers 2023-09-21T12:39:06.761759Z

how do i parametrize column names in an INSERT INTO?

erwinrooijakkers 2023-09-21T12:40:13.561389Z

I tried

INSERT INTO :identifier:table-name :value*:columns
VALUES :tuple*:rows;
but this throws
1. Unhandled com.microsoft.sqlserver.jdbc.SQLServerException
   Incorrect syntax near '@P0'.

erwinrooijakkers 2023-09-21T12:40:32.162389Z

same when wrapping :value*:columns in ()