Interactive Queries
Learn how to query data in ReifyDB with interactive examples. You can run these queries directly in your browser!
Basic Queries
SELECT Statement
The most fundamental query in ReifyDB is the SELECT statement. Try running this query to see all users:
Loading...
Ctrl+Enter to executeDisconnected
Filtering with WHERE
You can filter results using the WHERE clause:
Loading...
Ctrl+Enter to executeDisconnected
Joining Tables
ReifyDB supports various types of joins to combine data from multiple tables:
Loading...
Ctrl+Enter to executeDisconnected
Aggregation
Use aggregation functions to summarize your data:
Loading...
Ctrl+Enter to executeDisconnected
Conditional Logic
ReifyDB supports CASE statements for conditional logic:
Loading...
Ctrl+Enter to executeDisconnected
Multiple Statements
You can run multiple SQL statements in a single execution. Each statement produces its own result table:
Loading...
Ctrl+Enter to executeDisconnected
Try Your Own Queries
The examples above are fully editable! You can:
- Modify the queries directly in the editor
- Add or remove statements
- See results for each statement separately
- Reset to the original query if needed
Want more space to experiment? Head over to the Playground for a full-featured SQL editor with:
- Syntax highlighting and auto-completion
- Schema explorer
- Query history
- Export capabilities