The question mark is a placeholder in your sql statement that is given a real value when the statement is executed. 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. As a workaround, i'm using the following.
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. Why are the names john/jane doe used as placeholder names instead of any other name? In postgres, the value placeholder is $#, which one is recommend when the value is the same, reusing the value placeholder or not?
It seems the query is ok, but it returns empty list or a. In sql systems other than postgres, such as mysql for instance, prepared statements can use question marks as a placeholder. How to use placeholders in postgresql? A function 'placeholder' has been used in a true/false expression that is used as a table filter expression.
They're known as query parameters.