Technically, you have the right amount, but you're missing parentheses and commas, and it's broken up throughout your query which i suspect is confusing sql. Truecan you add an array as an sqlite query placeholder? In sql systems other than postgres, such as mysql for instance, prepared statements can use question marks as a placeholder.
What i’ve prepared for now is a preliminary poll, where people would decide for example on the actual categories and numbers of nominations, as well as on what are their. It seems the query is ok, but it returns empty list or a. They're known as query parameters.
In postgres, the value placeholder is $#, which one is recommend when the value is the same, reusing the value placeholder or not? Even just a list query shows nothing, i tried a lot of stuff i found on internet, i even asked ai for help, but it didn't work. For i, c := range columns { if i == 0 { *query += c placeholder += ? } else { *query += , +c placeholder += , ? } } placeholder += ) *query += ) + placeholder } // convert. Why are the names john/jane doe used as placeholder names instead of any other name?
How to use placeholders in postgresql?