Queries — overview
How Liberty's Connectors page is organised — Tables / Unclassified / Sequences / Lookups — and the four kinds of queries each tab manages.
Create from a database table
The CRUD Wizard — point Liberty at an existing table, tick the columns, get the four CRUD queries auto-generated and saved in one click.
Create a custom query
Write a standalone query by hand — the Unclassified tab, the editor form, the writable gate, the params block, the SQL editor with autocompletion.
Clone a query or a connector
Duplicate one query inside a connector, duplicate every CRUD query of a table, or clone a whole application (connector + dictionary + screens + menu + dashboards + charts).
Sequences and lookups
The Scaffold modal — tick a table and a column, get a generated sequence (next id) or lookup (value + label) query plus the matching dictionary entry, saved in one click.
Parameter binding
How `:placeholder` params get values at runtime — declared defaults, screen-column sources, reserved built-ins like #LOGIN_USER# / #SYSDATE#, and per-call literal overrides.
Per-dialect SQL variants
Ship one Liberty query with different SQL on Postgres, Oracle, MySQL, SQL Server, SQLite and DB2 — the per-dialect `sql` map, when to use it, common gotchas.