Beginner-friendly dynamic queries

Build Qornix Dynamic API requests visually

Start with plain SQL-like examples, convert them to Qornix JSON payloads, then run the request against /api/dynamic. The page also exposes metadata endpoints, joins, group by, having, sorting, limits and write payloads.

1. Convert SQL to Qornix JSON

Paste a simple SELECT. The converter understands SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY and LIMIT. It produces the JSON body used by POST /api/dynamic.

Tip: for joined requests the current server can execute raw JOIN clauses when the template enables allowRawJoin. Field allowlist validation is still table-centric, so the safest first join example uses SELECT *.

2. Choose endpoint and table

Tables and fields are loaded from the schema allowlist. After first start, apply demo schema and seed rows from the landing page or Schema Manager.

HTTP method

Table

3. Query parameters

SELECT fields

Structured WHERE

Raw filter strings

JOIN

4. Advanced parameters

GROUP BY

HAVING

ORDER BY

LIMIT

Data for POST/PUT/PATCH

5. JSON payload

Ready.

6. API response

Response will appear here.

Table preview

Run a request to see rows.