Skip to main content

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 editor...

Filtering with WHERE​

You can filter results using the WHERE clause:

Loading editor...

Joining Tables​

ReifyDB supports various types of joins to combine data from multiple tables:

Loading editor...

Aggregation​

Use aggregation functions to summarize your data:

Loading editor...

Conditional Logic​

ReifyDB supports CASE statements for conditional logic:

Loading editor...

Multiple Statements​

You can run multiple SQL statements in a single execution. Each statement produces its own result table:

Loading editor...

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

Next Steps​