Upsolve uses Trino’s ANSI SQL compliant query engine. This standard compliance allows Upsolve users to integrate their
favorite data tools, including BI and ETL tools with any underlying data source.Our query engine validates and translates the received SQL statements into the necessary operations on the connected
data source.This section provides a reference to the supported SQL data types and other general characteristics of the SQL support
of Upsolve.
Was this page helpful?
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Upsolve AI","colors":{"primary":"#F13470","light":"#F13470","dark":"#E05883"},"favicon":"https://mintcdn.com/upsolve/yo8HqJNiSHXxC-XO/favicon.svg?fit=max\u0026auto=format\u0026n=yo8HqJNiSHXxC-XO\u0026q=85\u0026s=9b9e554a8bc33ff2f4191464242d130d","logo":{"light":"https://mintcdn.com/upsolve/2iK7L-lfLcwqCcz_/logo/light_logo.svg?fit=max\u0026auto=format\u0026n=2iK7L-lfLcwqCcz_\u0026q=85\u0026s=e2c715b3dad371be16e683c74655b2a8","dark":"https://mintcdn.com/upsolve/2iK7L-lfLcwqCcz_/logo/dark_logo.svg?fit=max\u0026auto=format\u0026n=2iK7L-lfLcwqCcz_\u0026q=85\u0026s=e5b53eb0a41de94b806015890a6b4bdc","href":"https://upsolve.ai"},"api":{"openapi":["api-reference/upsolve.documentation.yaml"],"mdx":{"server":"https://api.upsolve.ai","auth":{"method":"bearer","name":null}}},"navbar":{"links":[{"label":"Support","href":"mailto:support@upsolve.ai"}],"primary":{"type":"button","label":"Request Access","href":"https://upsolve.ai/"}},"footer":{"socials":{"website":"https://upsolve.ai/","linkedin":"https://www.linkedin.com/company/upsolveai","hacker-news":"https://www.ycombinator.com/companies/upsolve-ai"}},"styling":{"latex":false},"navigation":{"global":{"anchors":[{"anchor":"Impact Studies","href":"https://upsolve.ai/impact-study","icon":"newspaper"},{"anchor":"Security Trust Center","href":"https://trust.upsolve.ai","icon":"shield-halved"},{"anchor":"Community","href":"https://upsolve-ai-community.slack.com/join/shared_invite/zt-2x9oospxx-vv2uDP_20IafkekwCOMi4A#/shared-invite/email","icon":"slack"},{"anchor":"Blog","href":"https://www.upsolve.com/blog","icon":"newspaper"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"upsolve","hasAudioNarration":false,"actualSubdomain":"upsolve","customDomains":["docs.upsolve.ai"],"gitSource":{"type":"github","owner":"upsolve-labs","repo":"upsolve-core","deployBranch":"main","contentDirectory":"apps/docs","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6ad9118f6689318e08e7f5fa","collectionId":"0cf3d1e9-24a1-4be9-a7b9-2d51d8565125","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ad9118f6689318e08e7f5fa"},"feedback":{"thumbs":true,"edits":true,"issues":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6adb93012d3c9c6f327a27e5","clientVersion":"0.0.3971","searchFilterCounts":[{"language":"default","tag":"Integrations","count":114},{"language":"default","tag":"SQL Reference","count":48},{"language":"default","tag":"API Reference","count":35},{"language":"default","tag":"Documentation","count":33},{"language":"default","tag":"API Documentation","count":26},{"language":"default","tag":"Functions","count":23},{"language":"default","tag":"Analytics Layer","count":22},{"language":"default","tag":"Routines","count":14},{"language":"default","tag":"Chart Configurations","count":12},{"language":"default","tag":"Chart Types","count":12}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[],"isAtlas":false,"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"sql/introduction","slug":"/sql/introduction","pageMetadata":{"title":"Introduction","description":"Introduction to how to use SQL with Upsolve.","href":"/sql/introduction"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Introduction to how to use SQL with Upsolve.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={p:`p`,..._provideComponents(),...props.components},{Heading}=_components;if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`welcome`,children:`Welcome`}),`\n`,_jsx(_components.p,{children:`Upsolve uses Trino’s ANSI SQL compliant query engine. This standard compliance allows Upsolve users to integrate their\nfavorite data tools, including BI and ETL tools with any underlying data source.`}),`\n`,_jsx(_components.p,{children:`Our query engine validates and translates the received SQL statements into the necessary operations on the connected\ndata source.`}),`\n`,_jsx(_components.p,{children:`This section provides a reference to the supported SQL data types and other general characteristics of the SQL support\nof Upsolve.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Introduction","description":"Introduction to how to use SQL with Upsolve.","href":"/sql/introduction"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Welcome","slug":"welcome","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"upsolve","siteName":"Upsolve AI","title":"Introduction - Upsolve AI","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2025-08-12T00:44:58.795Z","originalFileLocation":"sql/introduction.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Introduction to how to use SQL with Upsolve.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Upsolve AI\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Introduction - Upsolve AI\">\u003cmeta data-mint-head property=\"og:description\" content=\"Introduction to how to use SQL with Upsolve.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Upsolve AI\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.upsolve.ai/sql/introduction\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://upsolve.mintlify.app/_mintlify/api/og/v2?division=SQL\u0026amp;title=Introduction\u0026amp;description=Introduction+to+how+to+use+SQL+with+Upsolve.\u0026amp;theme=ee308efe25f936e82bf32ff5\u0026amp;signature=ffcf8f92f1fd0470e0aaf3d0889cfc93155205209e935704e352a793ccb5d906\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Introduction - Upsolve AI\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Introduction to how to use SQL with Upsolve.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://upsolve.mintlify.app/_mintlify/api/og/v2?division=SQL\u0026amp;title=Introduction\u0026amp;description=Introduction+to+how+to+use+SQL+with+Upsolve.\u0026amp;theme=ee308efe25f936e82bf32ff5\u0026amp;signature=ffcf8f92f1fd0470e0aaf3d0889cfc93155205209e935704e352a793ccb5d906\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/upsolve/294UabaKv711UkJe/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Upsolve AI\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#F13470\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.upsolve.ai/sql/introduction\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/sql/introduction.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.upsolve.ai/#organization\",\"name\":\"Upsolve AI\",\"url\":\"https://docs.upsolve.ai\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/upsolve/2iK7L-lfLcwqCcz_/logo/light_logo.svg?fit=max\u0026auto=format\u0026n=2iK7L-lfLcwqCcz_\u0026q=85\u0026s=e2c715b3dad371be16e683c74655b2a8\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.upsolve.ai#website\",\"name\":\"Upsolve AI\",\"url\":\"https://docs.upsolve.ai\",\"publisher\":{\"@id\":\"https://docs.upsolve.ai/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.upsolve.ai/sql/introduction#webpage\",\"url\":\"https://docs.upsolve.ai/sql/introduction\",\"name\":\"Introduction\",\"description\":\"Introduction to how to use SQL with Upsolve.\",\"dateModified\":\"2025-08-12T00:44:58.795Z\",\"isPartOf\":{\"@id\":\"https://docs.upsolve.ai#website\"},\"breadcrumb\":{\"@id\":\"https://docs.upsolve.ai/sql/introduction#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.upsolve.ai/sql/introduction#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Upsolve AI\",\"item\":\"https://docs.upsolve.ai\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction\",\"item\":\"https://docs.upsolve.ai/sql/introduction\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.upsolve.ai/sql/introduction#article\",\"headline\":\"Introduction\",\"name\":\"Introduction\",\"description\":\"Introduction to how to use SQL with Upsolve.\",\"url\":\"https://docs.upsolve.ai/sql/introduction\",\"mainEntityOfPage\":{\"@id\":\"https://docs.upsolve.ai/sql/introduction#webpage\"},\"dateModified\":\"2025-08-12T00:44:58.795Z\",\"publisher\":{\"@id\":\"https://docs.upsolve.ai/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.upsolve.ai#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Upsolve AI\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Upsolve AI","nav":{"global":{"anchors":[{"anchor":"Impact Studies","href":"https://upsolve.ai/impact-study","icon":"newspaper"},{"anchor":"Security Trust Center","href":"https://trust.upsolve.ai","icon":"shield-halved"},{"anchor":"Community","href":"https://upsolve-ai-community.slack.com/join/shared_invite/zt-2x9oospxx-vv2uDP_20IafkekwCOMi4A#/shared-invite/email","icon":"slack"},{"anchor":"Blog","href":"https://www.upsolve.com/blog","icon":"newspaper"}]},"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/introduction"}]},{"tab":"Analytics Layer","pages":[{"title":"Analytics Layer","href":"/embedded-bi/introduction"}]},{"tab":"Integrations","pages":[{"title":"Integrations","href":"/integrations/introduction"}]},{"tab":"Chart Configurations","pages":[{"title":"Chart Configurations","href":"/content/charts/area-line-chart"}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/api-reference/endpoint/create-embed-token"}]},{"tab":"SQL Reference","groups":[{"group":"SQL","pages":[{"title":"Introduction","href":"/sql/introduction"}]},{"group":"Reference","pages":[{"title":"DESCRIBE","description":null,"href":"/sql/reference/describe"},{"title":"EXECUTE","href":"/sql/reference/execute"},{"title":"PREPARE","href":"/sql/reference/prepare"},{"title":"SELECT","href":"/sql/reference/select"},{"title":"SHOW CATALOGS","href":"/sql/reference/show-catalogs"},{"title":"SHOW COLUMNS","href":"/sql/reference/show-columns"},{"title":"SHOW SCHEMAS","href":"/sql/reference/show-schemas"},{"title":"USE","href":"/sql/reference/use"},{"title":"VALUES","href":"/sql/reference/values"}]},{"group":"Data Types","pages":[{"title":"Data types","href":"/sql/reference/types"}]},{"group":"Functions","pages":[{"title":"Aggregate functions","href":"/sql/functions/aggregate"},{"title":"Array functions and operators","href":"/sql/functions/array"},{"title":"Binary functions and operators","href":"/sql/functions/binary"},{"title":"Bitwise functions","href":"/sql/functions/bitwise"},{"title":"Comparison functions and operators","href":"/sql/functions/comparison"},{"title":"Conditional Expressions","href":"/sql/functions/conditional"},{"title":null,"href":"/sql/functions/conversion"},{"title":"Date and time functions and operators","href":"/sql/functions/datetime"},{"title":"Decimal functions and operators","href":"/sql/functions/decimal"},{"title":"HyperLogLog Functions","href":"/sql/functions/hyperloglog"},{"title":"JSON functions and operators","href":"/sql/functions/json"},{"title":"Lambda expressions","href":"/sql/functions/lambda"},{"title":null,"href":"/sql/functions/map"},{"title":"Machine learning functions","href":"/sql/functions/ml"},{"title":"Quantile digest functions","href":"/sql/functions/qdigest"},{"title":null,"href":"/sql/functions/regexp"},{"title":"Set Digest functions","href":"/sql/functions/setdigest"},{"title":"String functions and operators","href":"/sql/functions/string"},{"title":"Table functions","href":"/sql/functions/table"},{"title":"Teradata functions","href":"/sql/functions/teradata"},{"title":"URL functions","href":"/sql/functions/url"},{"title":"UUID Functions","href":"/sql/functions/uuid"},{"title":"Window functions","href":"/sql/functions/window"}]},{"group":"Routines","pages":[{"title":"Introduction to SQL routines","href":"/sql/routines/introduction"},{"title":"Example SQL routines","href":"/sql/routines/examples"},{"title":"BEGIN","href":"/sql/routines/begin"},{"title":"CASE","href":"/sql/routines/case"},{"title":"DECLARE","href":"/sql/routines/declare"},{"title":"FUNCTION","href":"/sql/routines/function"},{"title":"IF","href":"/sql/routines/if"},{"title":"ITERATE","href":"/sql/routines/iterate"},{"title":"LEAVE","href":"/sql/routines/leave"},{"title":"LOOP","href":"/sql/routines/loop"},{"title":"REPEAT","href":"/sql/routines/repeat"},{"title":"RETURN","href":"/sql/routines/return"},{"title":"SET","href":"/sql/routines/set"},{"title":"WHILE","href":"/sql/routines/while"}]}]},{"tab":"Demo","pages":[{"title":"Demo","href":"/demo/product-walkthrough"}]}]},"title":"Introduction - Upsolve AI","buildId":"dpl_DFJrtvUi8HS5F9nkooKuDJsuD5BM","deploymentId":"dpl_DFJrtvUi8HS5F9nkooKuDJsuD5BM","dynamics":[],"chunks":[]}