SQL Builder

Build Query
Pick a base table, select fields, and generate a starter SQL query.
Base table
Query template
Join table
Suggested joins found: 0 ยท Relationship entries on base table: 0
No FK-based join suggestions found for the current base table.
WHERE
ORDER BY
Limit
Fields
Generated SQL
Starter query pattern inspired by data-dictionary/query-builder tools.
SELECT
  t.*
FROM INVOICE t
-- WHERE <conditions>
-- ORDER BY <field>
FETCH FIRST 100 ROWS ONLY;