Parameterized SQL SELECT Builder
Generate a PostgreSQL SELECT with placeholders and parameter values.
Processing stays in your browser. Supports AND conditions with =, !=, <, <=, >, >= and IS NULL/IS NOT NULL. Supply the parameter array through your database driver; no query is executed.
How to use the parameterized sql select builder
Generate a PostgreSQL SELECT with placeholders and parameter values. Complete the table name, columns (comma-separated), conditions json array, row limit fields above, or upload a UTF-8 text file for conditions json array. Choose Run tool, review the output, then copy or download the result.
Example
An active condition becomes "active" = $1 with parameter true.
Good to know
Supports AND conditions with =, !=, <, <=, >, >= and IS NULL/IS NOT NULL. Supply the parameter array through your database driver; no query is executed.