Skip to main content
Saved queries let you store and share frequently used SQL expressions. They are scoped to your organization.

​
List saved queries

oleander queries list
Pass --json for machine-readable output: 
oleander queries list --json
Example output: 
Saved queries
- name: top_customers
  id: sq_abc123
  updated: 2026-05-01T12:00:00Z
  by: alice
  query: SELECT customer_id, sum(revenue) AS total FROM orders ...

​
Get a saved query

Print the full details of a saved query by name: 
oleander queries get <name>
To print only the SQL (useful for piping into oleander query): 
oleander queries get <name> --query-only
Example — run a saved query directly: 
oleander query "$(oleander queries get top_customers --query-only)"
Pass --json to get the raw JSON response: 
oleander queries get top_customers --json

​
Save a query

oleander queries save <name> "<sql>"
If a query with the same name exists it is replaced. Example: 
oleander queries save top_customers \
  "SELECT customer_id, sum(revenue) AS total FROM oleander.default.orders GROUP BY 1 ORDER BY 2 DESC LIMIT 20"