René's URL Explorer Experiment


Title: Query format in the SQL API - Cube Documentation

Open Graph Title: Query format in the SQL API - Cube Documentation

X Title: Query format in the SQL API - Cube Documentation

Description: SQL API runs queries in the Postgres dialect that can reference those tables and columns.

Open Graph Description: SQL API runs queries in the Postgres dialect that can reference those tables and columns.

X Description: SQL API runs queries in the Postgres dialect that can reference those tables and columns.

Opengraph URL: https://docs.cube.dev/reference/core-data-apis/sql-api/query-format

Generator: Mintlify

direct link

Domain: docs.cube.dev

IPv4 address: 76.76.21.164


Hey, it has json ld scripts:
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://docs.cube.dev/#organization","name":"Cube Documentation","url":"https://docs.cube.dev","logo":{"@type":"ImageObject","url":"https://mintcdn.com/cubed3/wCTntgEXVYYYnx4l/logo/light.svg?fit=max&auto=format&n=wCTntgEXVYYYnx4l&q=85&s=8bbf45ba64eac6116629064fac55aad7"}},{"@type":"WebSite","@id":"https://docs.cube.dev#website","name":"Cube Documentation","url":"https://docs.cube.dev","publisher":{"@id":"https://docs.cube.dev/#organization"}},{"@type":"WebPage","@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#webpage","url":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format","name":"Query format in the SQL API","description":"SQL API runs queries in the Postgres dialect that can reference those tables and columns.","dateModified":"2026-11-14T14:24:10.142Z","isPartOf":{"@id":"https://docs.cube.dev#website"},"breadcrumb":{"@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#breadcrumb"}},{"@type":"BreadcrumbList","@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Core Data APIs","item":"https://docs.cube.dev/reference/core-data-apis"},{"@type":"ListItem","position":2,"name":"SQL API","item":"https://docs.cube.dev/reference/core-data-apis/sql-api"},{"@type":"ListItem","position":3,"name":"Query format in the SQL API","item":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format"}]},{"@type":["Article","TechArticle"],"@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#article","headline":"Query format in the SQL API","name":"Query format in the SQL API","description":"SQL API runs queries in the Postgres dialect that can reference those tables and columns.","url":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format","mainEntityOfPage":{"@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#webpage"},"dateModified":"2026-11-14T14:24:10.142Z","publisher":{"@id":"https://docs.cube.dev/#organization"},"isPartOf":{"@id":"https://docs.cube.dev#website"}}]}
{"@context":"https://schema.org","@type":"WebSite","name":"Cube Documentation","publisher":{"@type":"Organization","name":"Cube Documentation"},"provider":{"@type":"Organization","name":"Mintlify","url":"https://mintlify.com"}}

application-nameCube Documentation
og:site_nameCube Documentation
og:typewebsite
og:imagehttps://cubed3.mintlify.site/_mintlify/api/og/v2?division=SQL+API&title=Query+format+in+the+SQL+API&description=SQL+API+runs+queries+in+the+Postgres+dialect+that+can+reference+those+tables+and+columns.&theme=6d1e003873cec4de62649d7c&signature=e1ab12b0f32d20fecb1045301d74f80b1b317bf0921ae4a334c97cc18c5cc3d0
og:image:width1200
og:image:height630
twitter:cardsummary_large_image
twitter:imagehttps://cubed3.mintlify.site/_mintlify/api/og/v2?division=SQL+API&title=Query+format+in+the+SQL+API&description=SQL+API+runs+queries+in+the+Postgres+dialect+that+can+reference+those+tables+and+columns.&theme=6d1e003873cec4de62649d7c&signature=e1ab12b0f32d20fecb1045301d74f80b1b317bf0921ae4a334c97cc18c5cc3d0
twitter:image:width1200
twitter:image:height630
msapplication-config/mintlify-assets/_mintlify/favicons/cubed3/JtLYPWhDFrYGSK8W/_generated/favicon/browserconfig.xml
apple-mobile-web-app-titleCube Documentation
msapplication-TileColor#5339CF

Links:

/llms.txthttps://docs.cube.dev/llms.txt
Skip to main contenthttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#content-area
Cube Documentation home pagehttps://docs.cube.dev/
Demoshttps://cube.dev/demos
Changeloghttps://cube.dev/changelog
Communityhttps://slack.cube.dev
Get Startedhttps://cubecloud.dev/auth/signup
Get Startedhttps://cubecloud.dev/auth/signup
Documentationhttps://docs.cube.dev/docs/introduction
Adminhttps://docs.cube.dev/admin/connect-to-data
Embeddinghttps://docs.cube.dev/embedding
Referencehttps://docs.cube.dev/reference/data-modeling/cube
Cube Corehttps://docs.cube.dev/cube-core
Recipeshttps://docs.cube.dev/recipes
APIhttps://docs.cube.dev/api-reference/introduction
Cubeshttps://docs.cube.dev/reference/data-modeling/cube
Viewshttps://docs.cube.dev/reference/data-modeling/view
View groupshttps://docs.cube.dev/reference/data-modeling/view-group
Measureshttps://docs.cube.dev/reference/data-modeling/measures
Dimensionshttps://docs.cube.dev/reference/data-modeling/dimensions
Hierarchieshttps://docs.cube.dev/reference/data-modeling/hierarchies
Segmentshttps://docs.cube.dev/reference/data-modeling/segments
Joinshttps://docs.cube.dev/reference/data-modeling/joins
Pre-aggregationshttps://docs.cube.dev/reference/data-modeling/pre-aggregations
Access policieshttps://docs.cube.dev/reference/data-modeling/data-access-policies
Context variableshttps://docs.cube.dev/reference/data-modeling/context-variables
Environment variableshttps://docs.cube.dev/reference/configuration/environment-variables
Configuration optionshttps://docs.cube.dev/reference/configuration/config
Overviewhttps://docs.cube.dev/reference/core-data-apis
Querying data APIshttps://docs.cube.dev/reference/core-data-apis/queries
Query format in the SQL APIhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format
Joins in the SQL APIhttps://docs.cube.dev/reference/core-data-apis/sql-api/joins
Authentication and Authorizationhttps://docs.cube.dev/reference/core-data-apis/sql-api/security
SQL API referencehttps://docs.cube.dev/reference/core-data-apis/sql-api/reference
Overviewhttps://docs.cube.dev/reference/embed-apis
Chat APIhttps://docs.cube.dev/reference/embed-apis/chat-api
Generate Sessionhttps://docs.cube.dev/reference/embed-apis/generate-session
Dashboard Commentshttps://docs.cube.dev/reference/embed-apis/dashboard-comments
Control Plane APIhttps://docs.cube.dev/reference/control-plane-api
Cube Store SQL commandshttps://docs.cube.dev/reference/cubestore/sql-commands
Cube CLIhttps://docs.cube.dev/reference/cli
Javascript sdkhttps://docs.cube.dev/reference/javascript-sdk
Reacthttps://docs.cube.dev/reference/javascript-sdk/react
Vuehttps://docs.cube.dev/reference/javascript-sdk/vue
Angularhttps://docs.cube.dev/reference/javascript-sdk/angular
Data model mappinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#data-model-mapping
Cubes and viewshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#cubes-and-views
Dimensionshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#dimensions
Measureshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#measures
Aggregate functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#aggregate-functions
Segmentshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#segments
Joinshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#joins
Post-processing and pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#post-processing-and-pushdown
Query post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
Query pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Top-down and bottom-up evaluationhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#top-down-and-bottom-up-evaluation
Aggregated and non-aggregated querieshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#aggregated-and-non-aggregated-queries
Filteringhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#filtering
Orderinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#ordering
Row limit edge casehttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#row-limit-edge-case
regular querieshttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
queries with post-processinghttps://docs.cube.dev/reference/core-data-apis/queries#query-with-post-processing
queries with pushdownhttps://docs.cube.dev/reference/core-data-apis/queries#query-with-pushdown
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#data-model-mapping
data modelhttps://docs.cube.dev/docs/data-modeling/overview
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#cubes-and-views
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#dimensions
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#measures
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#aggregate-functions
measure typeshttps://docs.cube.dev/reference/data-modeling/measures#type
avghttps://docs.cube.dev/reference/data-modeling/measures#type
booleanhttps://docs.cube.dev/reference/data-modeling/measures#type
counthttps://docs.cube.dev/reference/data-modeling/measures#type
count_distincthttps://docs.cube.dev/reference/data-modeling/measures#type
count_distinct_approxhttps://docs.cube.dev/reference/data-modeling/measures#type
maxhttps://docs.cube.dev/reference/data-modeling/measures#type
minhttps://docs.cube.dev/reference/data-modeling/measures#type
numberhttps://docs.cube.dev/reference/data-modeling/measures#type
stringhttps://docs.cube.dev/reference/data-modeling/measures#type
sumhttps://docs.cube.dev/reference/data-modeling/measures#type
timehttps://docs.cube.dev/reference/data-modeling/measures#type
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#segments
boolean typehttps://www.postgresql.org/docs/current/datatype-boolean.html
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#joins
refer to this pagehttps://docs.cube.dev/reference/core-data-apis/sql-api/joins
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#post-processing-and-pushdown
regular querieshttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
queries with post-processinghttps://docs.cube.dev/reference/core-data-apis/queries#query-with-post-processing
queries with pushdownhttps://docs.cube.dev/reference/core-data-apis/queries#query-with-pushdown
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
regular queryhttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
SQL API referencehttps://docs.cube.dev/reference/core-data-apis/sql-api/reference
selectionhttps://stackoverflow.com/a/1031101
projectionhttps://stackoverflow.com/a/1031101
regular queryhttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
post-processinghttps://docs.cube.dev/reference/core-data-apis/queries#query-with-post-processing
query pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
CUBESQL_SQL_PUSH_DOWNhttps://docs.cube.dev/reference/configuration/environment-variables#cubesql_sql_push_down
regular queryhttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
regular queryhttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
SQL API referencehttps://docs.cube.dev/reference/core-data-apis/sql-api/reference
UNIONhttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#union
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#top-down-and-bottom-up-evaluation
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#aggregated-and-non-aggregated-queries
any typehttps://docs.cube.dev/reference/data-modeling/measures#type
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#filtering
regular queryhttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
post-processinghttps://docs.cube.dev/reference/core-data-apis/queries#query-with-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#ordering
regular queryhttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
https://docs.cube.dev/reference/core-data-apis/sql-api/query-format#row-limit-edge-case
post-processinghttps://docs.cube.dev/reference/core-data-apis/queries#query-with-post-processing
regular queryhttps://docs.cube.dev/reference/core-data-apis/queries#regular-query
50,000 rowshttps://docs.cube.dev/reference/core-data-apis/queries#row-limit
CUBEJS_DB_QUERY_LIMIThttps://docs.cube.dev/reference/configuration/environment-variables#cubejs_db_query_limit
CUBESQL_NON_STREAMING_QUERY_MAX_ROW_LIMIThttps://docs.cube.dev/reference/configuration/environment-variables#cubesql_non_streaming_query_max_row_limit
CUBESQL_STREAM_MODEhttps://docs.cube.dev/reference/configuration/environment-variables#cubesql_stream_mode
Cube Corehttps://docs.cube.dev/reference/core-data-apis/sql-api
Joins in the SQL APIhttps://docs.cube.dev/reference/core-data-apis/sql-api/joins
Cube Documentation home pagehttps://docs.cube.dev/
xhttps://x.com/the_cube_dev
githubhttps://github.com/cube-js/cube
linkedinhttps://www.linkedin.com/company/cube-dev
Privacy Policyhttps://cube.dev/legal/privacy-policy
Cookie Preferenceshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#cookie-preferences
xhttps://x.com/the_cube_dev
githubhttps://github.com/cube-js/cube
linkedinhttps://www.linkedin.com/company/cube-dev
Powered byThis documentation is built and hosted on Mintlify, a developer documentation platformhttps://www.mintlify.com?utm_campaign=poweredBy&utm_medium=referral&utm_source=cubed3

Response headers:
ServerVercel
Content-Typetext/html; charset=utf-8
Cache-Controlno-store, no-cache, must-revalidate, proxy-revalidate, max-age=0
Last-ModifiedSun, 22 Nov 2026 19:32:28 GMT

Viewport: width=device-width, initial-scale=1, viewport-fit=cover


URLs of crawlers that visited me.