Query variables
Scale reporting with query variables
Define flexible variables so business users can safely customize and refresh reports.
PopSQL is trusted by 2000+ of the world's top data teams
No-code customization
Empower business users
Let business users and execs customize their own reports without requiring an analyst for every question.
Protect analyst time
Let analysts focus on high-impact projects, rather than repeat ad-hoc requests. On average, analysts save 40 hours per month.
Flexible ways to customize reports
Multiple types
PopSQL supports multiple variable types: string, number, date, boolean, dropdown, and multiselect.
If / else statements
SQL doesn't support if/else statements or variables out of the box. PopSQL makes your SQL dynamic with Liquid.
Works with dashboards & schedules
Query variables can be used outside your query too. Use it to power dashboards or recurring schedules for stakeholders.
SQL-powered variables
Write a query to update dropdown and multiselect lists dynamically.
Why PopSQL?
PopSQL enables your team to leverage existing infrastructure and tooling, elevating your workflow.
Works with any database
PopSQL supports every major database provider out there.
