Connectors
A connector is how Liberty Next reaches a data source: a SQL connector holds the named queries of a database pool, an API connector the named endpoints of a web API. Edited in Liberty Next → Build → Connectors; a connector with a menu is an app.
Queries — overview
How Liberty's Connectors page is organised — Settings / Tables / Queries / Sequences / Lookups — and the four kinds of queries it holds.
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 Queries view, the editor form, the writable switch, the params block, the SQL editor with autocompletion and tokens.
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 a query's :name parameters get their values — declared defaults on the query, param_binds on the caller (fixed value, another field, #LOGIN_USER# / #SYSDATE# built-ins), and {{LOGIN}} / {{SYSDATE}} tokens resolved by the server.
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.