René's URL Explorer Experiment


Title: SQL API reference - Cube Documentation

Open Graph Title: SQL API reference - Cube Documentation

X Title: SQL API reference - Cube Documentation

Description: SQL API supports the following commands as well as functions and operators.

Open Graph Description: SQL API supports the following commands as well as functions and operators.

X Description: SQL API supports the following commands as well as functions and operators.

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

Generator: Mintlify

direct link

Domain: docs.cube.dev

IPv4 address: 66.33.60.34


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/reference#webpage","url":"https://docs.cube.dev/reference/core-data-apis/sql-api/reference","name":"SQL API reference","description":"SQL API supports the following commands as well as functions and operators.","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/reference#breadcrumb"}},{"@type":"BreadcrumbList","@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/reference#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":"SQL API reference","item":"https://docs.cube.dev/reference/core-data-apis/sql-api/reference"}]},{"@type":["Article","TechArticle"],"@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/reference#article","headline":"SQL API reference","name":"SQL API reference","description":"SQL API supports the following commands as well as functions and operators.","url":"https://docs.cube.dev/reference/core-data-apis/sql-api/reference","mainEntityOfPage":{"@id":"https://docs.cube.dev/reference/core-data-apis/sql-api/reference#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=SQL+API+reference&description=SQL+API+supports+the+following+commands+as+well+as+functions+and+operators.&theme=6d1e003873cec4de62649d7c&signature=ee6beef46b47c165105f63f8391197509f55b9d7decbb9743dc044d0835c2f5a
og:image:width1200
og:image:height630
twitter:cardsummary_large_image
twitter:imagehttps://cubed3.mintlify.site/_mintlify/api/og/v2?division=SQL+API&title=SQL+API+reference&description=SQL+API+supports+the+following+commands+as+well+as+functions+and+operators.&theme=6d1e003873cec4de62649d7c&signature=ee6beef46b47c165105f63f8391197509f55b9d7decbb9743dc044d0835c2f5a
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/reference#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
SQL commandshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#sql-commands
SELECThttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#select
UNIONhttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#union
EXPLAINhttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#explain
SHOWhttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#show
SEThttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#set
CREATE TEMPORARY TABLEhttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#create-temporary-table
COPYhttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#copy
SQL functions and operatorshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#sql-functions-and-operators
Comparison operatorshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#comparison-operators
Comparison predicateshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#comparison-predicates
Mathematical functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#mathematical-functions
Trigonometric functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#trigonometric-functions
String functions and operatorshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#string-functions-and-operators
Other string functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#other-string-functions
Pattern matchinghttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#pattern-matching
Data type formatting functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#data-type-formatting-functions
Date/time functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#date%2Ftime-functions
Conditional expressionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#conditional-expressions
General-purpose aggregate functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#general-purpose-aggregate-functions
Aggregate functions for statisticshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#aggregate-functions-for-statistics
Window functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#window-functions
Row and array comparisonshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#row-and-array-comparisons
Custom functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#custom-functions
SQL APIhttps://docs.cube.dev/reference/core-data-apis/sql-api
commandshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#sql-commands
functions and operatorshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#sql-functions-and-operators
issues on GitHubhttps://github.com/cube-js/cube/issues?q=is%3Aopen+is%3Aissue+label%3Aapi%3Asql
file a new onehttps://github.com/cube-js/cube/issues/new?assignees=&labels=&projects=&template=sql_api_query_issue.md&title=
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#sql-commands
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#select
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#union
query pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
row limithttps://docs.cube.dev/reference/core-data-apis/queries#row-limit
query post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
Querying across data sourceshttps://docs.cube.dev/recipes/data-modeling/cross-data-source-queries
edge casehttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#row-limit-edge-case
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#explain
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#show
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#set
cache controlhttps://docs.cube.dev/reference/core-data-apis/sql-api#cache-control
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#create-temporary-table
COPYhttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#copy
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#copy
temporary tablehttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#create-temporary-table
in PostgreSQLhttps://www.postgresql.org/docs/current/sql-copy.html
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#sql-functions-and-operators
supported by PostgreSQLhttps://www.postgresql.org/docs/current/functions.html
custom functionshttps://docs.cube.dev/reference/core-data-apis/sql-api/reference#custom-functions
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#comparison-operators
relevant sectionhttps://www.postgresql.org/docs/current/functions-comparison.html#FUNCTIONS-COMPARISON-OP-TABLE
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#comparison-predicates
relevant sectionhttps://www.postgresql.org/docs/current/functions-comparison.html#FUNCTIONS-COMPARISON-PRED-TABLE
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#mathematical-functions
relevant sectionhttps://www.postgresql.org/docs/current/functions-math.html#FUNCTIONS-MATH-FUNC-TABLE
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#trigonometric-functions
relevant sectionhttps://www.postgresql.org/docs/current/functions-math.html#FUNCTIONS-MATH-TRIG-TABLE
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#string-functions-and-operators
relevant sectionhttps://www.postgresql.org/docs/current/functions-string.html#FUNCTIONS-STRING-SQL
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#other-string-functions
relevant sectionhttps://www.postgresql.org/docs/current/functions-string.html#FUNCTIONS-STRING-OTHER
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#pattern-matching
relevant sectionhttps://www.postgresql.org/docs/current/functions-matching.html
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#data-type-formatting-functions
relevant sectionhttps://www.postgresql.org/docs/current/functions-formatting.html
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#date/time-functions
relevant sectionhttps://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TABLE
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
default granularitieshttps://docs.cube.dev/docs/data-modeling/dimensions#time-dimensions
Redshifthttps://docs.aws.amazon.com/redshift/latest/dg/r_DATEDIFF_function.html
Custom granularitieshttps://docs.cube.dev/reference/data-modeling/dimensions#granularities
metadatahttps://docs.cube.dev/reference/core-data-apis/rest-api/reference#metadata-api
REST APIhttps://docs.cube.dev/reference/core-data-apis/rest-api
GraphQL APIhttps://docs.cube.dev/reference/core-data-apis/graphql-api
proxy dimensionhttps://docs.cube.dev/docs/data-modeling/dimensions#time-dimension-granularity-references
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#conditional-expressions
relevant sectionhttps://www.postgresql.org/docs/current/functions-conditional.html
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#general-purpose-aggregate-functions
relevant sectionhttps://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
any typehttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#aggregate-functions
compatible typeshttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#aggregate-functions
post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#aggregate-functions-for-statistics
relevant sectionhttps://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#window-functions
relevant sectionhttps://www.postgresql.org/docs/current/tutorial-window.html
query pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
query post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
edge casehttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#row-limit-edge-case
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#row-and-array-comparisons
relevant sectionhttps://www.postgresql.org/docs/current/functions-comparisons.html
Pushdownhttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-pushdown
Post-processinghttps://docs.cube.dev/reference/core-data-apis/sql-api/query-format#query-post-processing
https://docs.cube.dev/reference/core-data-apis/sql-api/reference#custom-functions
internal rate of returnhttps://support.microsoft.com/en-us/office/xirr-function-de1242ec-6477-445b-b11b-a303ad9adc9d
XIRR function referencehttps://docs.cube.dev/reference/core-data-apis/xirr
XIRR recipehttps://docs.cube.dev/recipes/data-modeling/xirr
Authentication and Authorizationhttps://docs.cube.dev/reference/core-data-apis/sql-api/security
REST (JSON) APIhttps://docs.cube.dev/reference/core-data-apis/rest-api
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/reference#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:45:35 GMT

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


URLs of crawlers that visited me.