Visual conditions
Compose filters as field → operator → value cards. Schema-aware inputs for numbers, dates, enums, and booleans.
Visual query builder
Lantern lets you build nested database filters by clicking — with live SQL preview, validation, and a simulated run against sample data.
SELECT * FROM users WHERE (age > 18 AND country = 'Nigeria') OR (status = 'active' AND purchases > 10);
From a single condition to deeply nested logic — Lantern keeps the UI simple and the generated query correct.
Compose filters as field → operator → value cards. Schema-aware inputs for numbers, dates, enums, and booleans.
Combine conditions with AND/OR groups at unlimited depth. Drag to reorder. Same power as hand-written SQL.
Watch SQL, MongoDB, and GraphQL output update as you build. One query tree, three export formats.
Catch incompatible operators, missing values, and empty groups before you run. Status dots on every card.
Run queries against sample users and orders data. Sort, paginate, and verify logic without a real database.
Export JSON, import saved queries, use presets and snapshots. Share filter logic with your team.
Pick a field, operator, and value for each rule on the canvas.
Group rules with AND/OR and preview the generated query instantly.
Run against mock data, then export JSON or copy SQL for production.
Open the builder and follow the getting started guide — you will have a nested filter running in under five minutes.