Fork me on GitHub
#hugsql
<
2023-09-21
>
erwinrooijakkers12:09:06

how do i parametrize column names in an INSERT INTO?

erwinrooijakkers12:09:13

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'.

erwinrooijakkers12:09:32

same when wrapping :value*:columns in ()