René's URL Explorer Experiment


Title: Supported SQL - PowerSync

Open Graph Title: Supported SQL - PowerSync

X Title: Supported SQL - PowerSync

Description: Reference for SQL syntax, operators, built-in functions, and type casting supported in Sync Streams queries.

Open Graph Description: Reference for SQL syntax, operators, built-in functions, and type casting supported in Sync Streams queries.

X Description: Reference for SQL syntax, operators, built-in functions, and type casting supported in Sync Streams queries.

Opengraph URL: https://docs.powersync.com/sync/supported-sql

Generator: Mintlify

direct link

Domain: docs.powersync.com

Hey, it has json ld scripts: 
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.powersync.com/#organization","name":"PowerSync","url":"https://www.powersync.com","logo":{"@type":"ImageObject","url":"https://docs.powersync.com/images/logo.png"},"sameAs":["https://github.com/powersync-ja","https://x.com/powersync_","https://www.linkedin.com/showcase/journeyapps-powersync/","https://bsky.app/profile/powersync.com"]},{"@type":"WebSite","@id":"https://docs.powersync.com#website","name":"PowerSync","url":"https://docs.powersync.com","publisher":{"@id":"https://www.powersync.com/#organization"}},{"@type":"WebPage","@id":"https://docs.powersync.com/sync/supported-sql#webpage","url":"https://docs.powersync.com/sync/supported-sql","name":"Supported SQL","description":"Reference for SQL syntax, operators, built-in functions, and type casting supported in Sync Streams queries.","dateModified":"2026-10-05T09:11:58.266Z","isPartOf":{"@id":"https://docs.powersync.com#website"},"breadcrumb":{"@id":"https://docs.powersync.com/sync/supported-sql#breadcrumb"}},{"@type":"BreadcrumbList","@id":"https://docs.powersync.com/sync/supported-sql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Sync Streams","item":"https://docs.powersync.com/sync/streams/overview"},{"@type":"ListItem","position":2,"name":"Supported SQL","item":"https://docs.powersync.com/sync/supported-sql"}]},{"@type":["Article","TechArticle"],"@id":"https://docs.powersync.com/sync/supported-sql#article","headline":"Supported SQL","name":"Supported SQL","description":"Reference for SQL syntax, operators, built-in functions, and type casting supported in Sync Streams queries.","url":"https://docs.powersync.com/sync/supported-sql","mainEntityOfPage":{"@id":"https://docs.powersync.com/sync/supported-sql#webpage"},"dateModified":"2026-10-05T09:11:58.266Z","publisher":{"@id":"https://www.powersync.com/#organization"},"isPartOf":{"@id":"https://docs.powersync.com#website"}}]}
 
{"@context":"https://schema.org","@type":"WebSite","name":"PowerSync","publisher":{"@type":"Organization","name":"PowerSync"},"provider":{"@type":"Organization","name":"Mintlify","url":"https://mintlify.com"}}
application-namePowerSync
og:site_namePowerSync
og:typewebsite
og:imagehttps://powersync.mintlify.site/_mintlify/api/og/v2?division=Reference&title=Supported+SQL&description=Reference+for+SQL+syntax,+operators,+built-in+functions,+and+type+casting+supported+in+Sync+Streams+queries.&theme=18174f9f4f4a1da907b109cc&signature=1d8eda5911c2e116a645a8d69ffe96c3c2282ceafa6982a458aba679be0452b2
og:image:width1200
og:image:height630
twitter:cardsummary_large_image
twitter:imagehttps://powersync.mintlify.site/_mintlify/api/og/v2?division=Reference&title=Supported+SQL&description=Reference+for+SQL+syntax,+operators,+built-in+functions,+and+type+casting+supported+in+Sync+Streams+queries.&theme=18174f9f4f4a1da907b109cc&signature=1d8eda5911c2e116a645a8d69ffe96c3c2282ceafa6982a458aba679be0452b2
twitter:image:width1200
twitter:image:height630
msapplication-config/mintlify-assets/_mintlify/favicons/powersync/dhIUAAc0qIG0PJBM/_generated/favicon/browserconfig.xml
apple-mobile-web-app-titlePowerSync
msapplication-TileColor#4e89ff
og:localeen_US

Links:

/llms.txthttps://docs.powersync.com/llms.txt
Skip to main contenthttps://docs.powersync.com/sync/supported-sql#content-area
PowerSync home pagehttps://www.powersync.com/
https://docs.powersync.com/intro/powersync-overview
Dashboardhttps://dashboard.powersync.com/
Get Startedhttps://accounts.powersync.com/portal/powersync-signup?s=docs
Get Startedhttps://accounts.powersync.com/portal/powersync-signup?s=docs
GitHubhttps://github.com/powersync-ja
Community Discordhttps://discord.com/invite/powersync
PowerSync Websitehttps://www.powersync.com/
Introductionhttps://docs.powersync.com/intro/powersync-overview
Setup Guidehttps://docs.powersync.com/intro/setup-guide
Exampleshttps://docs.powersync.com/intro/examples
Self-Hostinghttps://docs.powersync.com/intro/self-hosting
Overviewhttps://docs.powersync.com/sync/streams/overview
Quickstarthttps://docs.powersync.com/sync/streams/quickstart
Supported SQLhttps://docs.powersync.com/sync/supported-sql
Grammar Referencehttps://docs.powersync.com/sync/grammar/sync-streams
Type Mappinghttps://docs.powersync.com/sync/types
Overviewhttps://docs.powersync.com/client-sdks/overview
ORM Supporthttps://docs.powersync.com/client-sdks/orms/overview
Sync Catch-Uphttps://docs.powersync.com/client-sdks/checkpoint-requests
Usage Exampleshttps://docs.powersync.com/client-sdks/usage-examples
Monitoring and Alertinghttps://docs.powersync.com/maintenance-ops/monitoring-and-alerting
Replication Laghttps://docs.powersync.com/maintenance-ops/replication-lag
Production Readiness Best Practiceshttps://docs.powersync.com/maintenance-ops/production-readiness-guide
Compacting Bucketshttps://docs.powersync.com/maintenance-ops/compacting-buckets
Overviewhttps://docs.powersync.com/integrations/overview
Neonhttps://docs.powersync.com/integrations/neon
Serverpodhttps://docs.powersync.com/integrations/serverpod
Overviewhttps://docs.powersync.com/tools/overview
CLIhttps://docs.powersync.com/tools/cli
PowerSync Dashboardhttps://docs.powersync.com/tools/powersync-dashboard
Sync Diagnostics Clienthttps://github.com/powersync-ja/powersync-js/tree/main/tools/diagnostics-app#readme
Local Developmenthttps://docs.powersync.com/tools/local-development
Terraform Providerhttps://docs.powersync.com/tools/terraform
AI Toolshttps://docs.powersync.com/tools/ai-tools
Performance and Limitshttps://docs.powersync.com/resources/performance-and-limits
Supported Platformshttps://docs.powersync.com/resources/supported-platforms
Feature Statushttps://docs.powersync.com/resources/feature-status
FAQhttps://docs.powersync.com/resources/faq
Local-First Softwarehttps://docs.powersync.com/resources/local-first-software
Contact Ushttps://docs.powersync.com/resources/contact-us
Sync Streamshttps://docs.powersync.com/sync/streams/overview
Sync Streams grammar referencehttps://docs.powersync.com/sync/grammar/sync-streams/index
Filtering: WHERE Clausehttps://docs.powersync.com/sync/supported-sql#filtering-where-clause
https://docs.powersync.com/sync/supported-sql#query-syntax
WHERE filteringhttps://docs.powersync.com/sync/supported-sql#filtering-where-clause
Subquerieshttps://docs.powersync.com/sync/streams/queries#using-subqueries
INNER JOINhttps://docs.powersync.com/sync/supported-sql#join-syntax
Common Table Expressions (CTEs)https://docs.powersync.com/sync/supported-sql#cte-and-with-syntax
expanding arrayshttps://docs.powersync.com/sync/streams/parameters#expanding-json-arrays
operatorshttps://docs.powersync.com/sync/supported-sql#operators
functionshttps://docs.powersync.com/sync/supported-sql#functions
Writing Querieshttps://docs.powersync.com/sync/streams/queries
https://docs.powersync.com/sync/supported-sql#filtering-where-clause
https://docs.powersync.com/sync/supported-sql#operators
Filtering: WHERE Clausehttps://docs.powersync.com/sync/supported-sql#filtering-where-clause
Filtering: WHERE Clausehttps://docs.powersync.com/sync/supported-sql#filtering-where-clause
https://docs.powersync.com/sync/supported-sql#functions
SQLite storage classeshttps://www.sqlite.org/datatype3.html
SQLite built-in functionshttps://www.sqlite.org/lang_corefunc.html
SQLite JSON functionshttps://www.sqlite.org/json1.html
upper(text)https://www.sqlite.org/lang_corefunc.html#upper
lower(text)https://www.sqlite.org/lang_corefunc.html#lower
substring(text, start, length)https://www.sqlite.org/lang_corefunc.html#substr
instr(string, substring)https://www.sqlite.org/lang_corefunc.html#instr
hex(data)https://www.sqlite.org/lang_corefunc.html#hex
length(data)https://www.sqlite.org/lang_corefunc.html#length
Type mappinghttps://docs.powersync.com/sync/types
SQLite typeshttps://www.sqlite.org/datatype3.html
typeof(data)https://www.sqlite.org/lang_corefunc.html#typeof
json_each(data)https://www.sqlite.org/json1.html#jeach
Expanding JSON arrayshttps://docs.powersync.com/sync/streams/parameters#expanding-json-arrays
json_extract(data, path)https://www.sqlite.org/json1.html#jex
json_array_length(data)https://www.sqlite.org/json1.html#jarraylen
json_valid(data)https://www.sqlite.org/json1.html#jvalid
ifnull(x, y)https://www.sqlite.org/lang_corefunc.html#ifnull
iif(x, y, z)https://www.sqlite.org/lang_corefunc.html#iif
unixepoch(time-value, [modifier])https://www.sqlite.org/lang_datefunc.html
datetime(time-value, [modifier])https://www.sqlite.org/lang_datefunc.html
uuid_blob(id)https://sqlite.org/src/file/ext/misc/uuid.c
wildcard schemahttps://docs.powersync.com/sync/advanced/schemas-and-connections#wildcard-schemas-postgres
wildcard table namehttps://docs.powersync.com/sync/advanced/partitioned-tables
ST_AsGeoJSON(geometry)https://docs.powersync.com/client-sdks/advanced/gis-data-postgis
PostGIShttps://docs.powersync.com/client-sdks/advanced/gis-data-postgis
ST_AsText(geometry)https://docs.powersync.com/client-sdks/advanced/gis-data-postgis
PostGIShttps://docs.powersync.com/client-sdks/advanced/gis-data-postgis
ST_X(point)https://docs.powersync.com/client-sdks/advanced/gis-data-postgis
PostGIShttps://docs.powersync.com/client-sdks/advanced/gis-data-postgis
ST_Y(point)https://docs.powersync.com/client-sdks/advanced/gis-data-postgis
PostGIShttps://docs.powersync.com/client-sdks/advanced/gis-data-postgis
contact ushttps://docs.powersync.com/resources/contact-us
https://docs.powersync.com/sync/supported-sql#join-syntax
Using Joinshttps://docs.powersync.com/sync/streams/queries#using-joins
https://docs.powersync.com/sync/supported-sql#cte-and-with-syntax
Common Table Expressions (CTEs)https://docs.powersync.com/sync/streams/ctes
https://docs.powersync.com/sync/supported-sql#case-expressions
Suggest editshttps://github.com/powersync-ja/powersync-docs/edit/main/sync/supported-sql.mdx
Raise issuehttps://github.com/powersync-ja/powersync-docs/issues/new?title=Issue on docs&body=Path: /sync/supported-sql
Examples, Patterns & DemosPrevioushttps://docs.powersync.com/sync/streams/examples
Grammar ReferenceNexthttps://docs.powersync.com/sync/grammar/sync-streams
Query Syntaxhttps://docs.powersync.com/sync/supported-sql#query-syntax
Filtering: WHERE Clausehttps://docs.powersync.com/sync/supported-sql#filtering-where-clause
Operatorshttps://docs.powersync.com/sync/supported-sql#operators
Functionshttps://docs.powersync.com/sync/supported-sql#functions
JOIN Syntaxhttps://docs.powersync.com/sync/supported-sql#join-syntax
CTE and WITH Syntaxhttps://docs.powersync.com/sync/supported-sql#cte-and-with-syntax
CASE Expressionshttps://docs.powersync.com/sync/supported-sql#case-expressions
PowerSync home pagehttps://www.powersync.com/
githubhttps://github.com/powersync-ja
discordhttps://discord.com/invite/powersync
blueskyhttps://bsky.app/profile/powersync.com
xhttps://x.com/powersync_
youtubehttps://www.youtube.com/@powersync_
linkedinhttps://www.linkedin.com/showcase/journeyapps-powersync
Release Noteshttps://releases.powersync.com
System Statushttps://status.powersync.com/
Roadmaphttps://roadmap.powersync.com
Bloghttps://www.powersync.com/blog
githubhttps://github.com/powersync-ja
discordhttps://discord.com/invite/powersync
blueskyhttps://bsky.app/profile/powersync.com
xhttps://x.com/powersync_
youtubehttps://www.youtube.com/@powersync_
linkedinhttps://www.linkedin.com/showcase/journeyapps-powersync
Powered byThis documentation is built and hosted on Mintlify, a developer documentation platformhttps://www.mintlify.com?utm_campaign=poweredBy&utm_medium=referral&utm_source=powersync

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

URLs of crawlers that visited me.