Column names should use Identifier List Params. In this case, you want them in () like so: (i*:columns) . https://www.hugsql.org/hugsql-in-detail/parameter-types/sql-identifier-list-parameters