Queries

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)"

To write its results to a table instead of printing them, send the same SQL to oleander query submit:

oleander query submit "$(oleander queries get top_customers --query-only)" \
  --destination default.top_customers_snapshot

oleander queries save stores the SQL text under a name. oleander query submit --destination writes the result set to a table. They are different things.

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"

Getting Started

Platform

Connections

Coding with agents

CLI

External Compute

List saved queries

Get a saved query

Save a query

​List saved queries

​Get a saved query

​Save a query

List saved queries

Get a saved query

Save a query