René's URL Explorer Experiment


Title: GitHub - cIark/sqlglot: Python SQL Parser and Transpiler

Open Graph Title: GitHub - cIark/sqlglot: Python SQL Parser and Transpiler

X Title: GitHub - cIark/sqlglot: Python SQL Parser and Transpiler

Description: Python SQL Parser and Transpiler. Contribute to cIark/sqlglot development by creating an account on GitHub.

Open Graph Description: Python SQL Parser and Transpiler. Contribute to cIark/sqlglot development by creating an account on GitHub.

X Description: Python SQL Parser and Transpiler. Contribute to cIark/sqlglot development by creating an account on GitHub.

Opengraph URL: https://github.com/cIark/sqlglot

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:8ea9d76f-e6d8-9693-c6dc-98d39c99fb9a
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-idBAF6:2C23AD:7281FAF:944D288:697E504D
html-safe-nonce5afba751741977a67b986d146e4597e6e80ce50af59e9a98df3b3e57b3670b73
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCQUY2OjJDMjNBRDo3MjgxRkFGOjk0NEQyODg6Njk3RTUwNEQiLCJ2aXNpdG9yX2lkIjoiODQyMTc3MjY4Njk2MjYxMDI1MyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmaccd208291b07882b082f4b0c98e1826f94f86e6c844acd7eb71cdae2e9b37a0e0
hovercard-subject-tagrepository:938555083
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/cIark/sqlglot
twitter:imagehttps://opengraph.githubassets.com/049aa25673821f970885b6ef2bbc0fa679047b6fb5c6b484c0b3aa65d6d8227f/cIark/sqlglot
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/049aa25673821f970885b6ef2bbc0fa679047b6fb5c6b484c0b3aa65d6d8227f/cIark/sqlglot
og:image:altPython SQL Parser and Transpiler. Contribute to cIark/sqlglot development by creating an account on GitHub.
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None60279d4097367e16897439d16d6bbe4180663db828c666eeed2656988ffe59f6
turbo-cache-controlno-preview
go-importgithub.com/cIark/sqlglot git https://github.com/cIark/sqlglot.git
octolytics-dimension-user_id22808067
octolytics-dimension-user_logincIark
octolytics-dimension-repository_id938555083
octolytics-dimension-repository_nwocIark/sqlglot
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id347277349
octolytics-dimension-repository_parent_nwotobymao/sqlglot
octolytics-dimension-repository_network_root_id347277349
octolytics-dimension-repository_network_root_nwotobymao/sqlglot
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release7c85641c598ad130c74f7bcc27f58575cac69551
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/cIark/sqlglot#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FcIark%2Fsqlglot
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FcIark%2Fsqlglot
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=cIark%2Fsqlglot
Reloadhttps://patch-diff.githubusercontent.com/cIark/sqlglot
Reloadhttps://patch-diff.githubusercontent.com/cIark/sqlglot
Reloadhttps://patch-diff.githubusercontent.com/cIark/sqlglot
cIark https://patch-diff.githubusercontent.com/cIark
sqlglothttps://patch-diff.githubusercontent.com/cIark/sqlglot
tobymao/sqlglothttps://patch-diff.githubusercontent.com/tobymao/sqlglot
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2FcIark%2Fsqlglot
Fork 0 https://patch-diff.githubusercontent.com/login?return_to=%2FcIark%2Fsqlglot
Star 0 https://patch-diff.githubusercontent.com/login?return_to=%2FcIark%2Fsqlglot
sqlglot.com/https://sqlglot.com/
MIT license https://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/LICENSE
0 stars https://patch-diff.githubusercontent.com/cIark/sqlglot/stargazers
1.1k forks https://patch-diff.githubusercontent.com/cIark/sqlglot/forks
Branches https://patch-diff.githubusercontent.com/cIark/sqlglot/branches
Tags https://patch-diff.githubusercontent.com/cIark/sqlglot/tags
Activity https://patch-diff.githubusercontent.com/cIark/sqlglot/activity
Star https://patch-diff.githubusercontent.com/login?return_to=%2FcIark%2Fsqlglot
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2FcIark%2Fsqlglot
Code https://patch-diff.githubusercontent.com/cIark/sqlglot
Pull requests 0 https://patch-diff.githubusercontent.com/cIark/sqlglot/pulls
Actions https://patch-diff.githubusercontent.com/cIark/sqlglot/actions
Projects 0 https://patch-diff.githubusercontent.com/cIark/sqlglot/projects
Security 0 https://patch-diff.githubusercontent.com/cIark/sqlglot/security
Insights https://patch-diff.githubusercontent.com/cIark/sqlglot/pulse
Code https://patch-diff.githubusercontent.com/cIark/sqlglot
Pull requests https://patch-diff.githubusercontent.com/cIark/sqlglot/pulls
Actions https://patch-diff.githubusercontent.com/cIark/sqlglot/actions
Projects https://patch-diff.githubusercontent.com/cIark/sqlglot/projects
Security https://patch-diff.githubusercontent.com/cIark/sqlglot/security
Insights https://patch-diff.githubusercontent.com/cIark/sqlglot/pulse
Brancheshttps://patch-diff.githubusercontent.com/cIark/sqlglot/branches
Tagshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tags
https://patch-diff.githubusercontent.com/cIark/sqlglot/branches
https://patch-diff.githubusercontent.com/cIark/sqlglot/tags
5,216 Commitshttps://patch-diff.githubusercontent.com/cIark/sqlglot/commits/main/
https://patch-diff.githubusercontent.com/cIark/sqlglot/commits/main/
.githubhttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/.github
.githubhttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/.github
benchmarkshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/benchmarks
benchmarkshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/benchmarks
docshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/docs
docshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/docs
pdochttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/pdoc
pdochttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/pdoc
postshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/posts
postshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/posts
sqlglothttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/sqlglot
sqlglothttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/sqlglot
sqlglotrshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/sqlglotrs
sqlglotrshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/sqlglotrs
testshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/tests
testshttps://patch-diff.githubusercontent.com/cIark/sqlglot/tree/main/tests
.gitignorehttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/.gitignore
.gitignorehttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/.gitignore
.gitpod.ymlhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/.gitpod.yml
.gitpod.ymlhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/.gitpod.yml
.pre-commit-config.yamlhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/.pre-commit-config.yaml
.pre-commit-config.yamlhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/.pre-commit-config.yaml
CHANGELOG.mdhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/CHANGELOG.md
CHANGELOG.mdhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/CHANGELOG.md
CONTRIBUTING.mdhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/CONTRIBUTING.md
CONTRIBUTING.mdhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/CONTRIBUTING.md
LICENSEhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/LICENSE
LICENSEhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/LICENSE
MANIFEST.inhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/MANIFEST.in
MANIFEST.inhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/MANIFEST.in
Makefilehttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/Makefile
Makefilehttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/Makefile
README.mdhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/README.md
README.mdhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/README.md
setup.cfghttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/setup.cfg
setup.cfghttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/setup.cfg
setup.pyhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/setup.py
setup.pyhttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/setup.py
sqlglot.pnghttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/sqlglot.png
sqlglot.pnghttps://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/sqlglot.png
READMEhttps://patch-diff.githubusercontent.com/cIark/sqlglot
Contributinghttps://patch-diff.githubusercontent.com/cIark/sqlglot
Licensehttps://patch-diff.githubusercontent.com/cIark/sqlglot
https://patch-diff.githubusercontent.com/cIark/sqlglot/blob/main/sqlglot.png
24 different dialectshttps://github.com/tobymao/sqlglot/blob/main/sqlglot/dialects/__init__.py
DuckDBhttps://duckdb.org/
Prestohttps://prestodb.io/
Trinohttps://trino.io/
Sparkhttps://spark.apache.org/
Databrickshttps://www.databricks.com/
Snowflakehttps://www.snowflake.com/en/
BigQueryhttps://cloud.google.com/bigquery/
test suitehttps://github.com/tobymao/sqlglot/blob/main/tests/
performanthttps://patch-diff.githubusercontent.com/cIark/sqlglot#benchmarks
customizehttps://patch-diff.githubusercontent.com/cIark/sqlglot#custom-dialects
analyzehttps://patch-diff.githubusercontent.com/cIark/sqlglot#metadata
buildhttps://patch-diff.githubusercontent.com/cIark/sqlglot#build-and-modify-sql
errorshttps://patch-diff.githubusercontent.com/cIark/sqlglot#parser-errors
documentationhttps://sqlglot.com/
primerhttps://github.com/tobymao/sqlglot/blob/main/posts/ast_primer.md
contribution guidehttps://github.com/tobymao/sqlglot/blob/main/CONTRIBUTING.md
onboarding documenthttps://github.com/tobymao/sqlglot/blob/main/posts/onboarding.md
https://patch-diff.githubusercontent.com/cIark/sqlglot#table-of-contents
Installhttps://patch-diff.githubusercontent.com/cIark/sqlglot#install
Versioninghttps://patch-diff.githubusercontent.com/cIark/sqlglot#versioning
Get in Touchhttps://patch-diff.githubusercontent.com/cIark/sqlglot#get-in-touch
FAQhttps://patch-diff.githubusercontent.com/cIark/sqlglot#faq
Exampleshttps://patch-diff.githubusercontent.com/cIark/sqlglot#examples
Formatting and Transpilinghttps://patch-diff.githubusercontent.com/cIark/sqlglot#formatting-and-transpiling
Metadatahttps://patch-diff.githubusercontent.com/cIark/sqlglot#metadata
Parser Errorshttps://patch-diff.githubusercontent.com/cIark/sqlglot#parser-errors
Unsupported Errorshttps://patch-diff.githubusercontent.com/cIark/sqlglot#unsupported-errors
Build and Modify SQLhttps://patch-diff.githubusercontent.com/cIark/sqlglot#build-and-modify-sql
SQL Optimizerhttps://patch-diff.githubusercontent.com/cIark/sqlglot#sql-optimizer
AST Introspectionhttps://patch-diff.githubusercontent.com/cIark/sqlglot#ast-introspection
AST Diffhttps://patch-diff.githubusercontent.com/cIark/sqlglot#ast-diff
Custom Dialectshttps://patch-diff.githubusercontent.com/cIark/sqlglot#custom-dialects
SQL Executionhttps://patch-diff.githubusercontent.com/cIark/sqlglot#sql-execution
Used Byhttps://patch-diff.githubusercontent.com/cIark/sqlglot#used-by
Documentationhttps://patch-diff.githubusercontent.com/cIark/sqlglot#documentation
Run Tests and Linthttps://patch-diff.githubusercontent.com/cIark/sqlglot#run-tests-and-lint
Benchmarkshttps://patch-diff.githubusercontent.com/cIark/sqlglot#benchmarks
Optional Dependencieshttps://patch-diff.githubusercontent.com/cIark/sqlglot#optional-dependencies
https://patch-diff.githubusercontent.com/cIark/sqlglot#install
https://patch-diff.githubusercontent.com/cIark/sqlglot#versioning
https://patch-diff.githubusercontent.com/cIark/sqlglot#get-in-touch
Slack channelhttps://tobikodata.com/slack
https://patch-diff.githubusercontent.com/cIark/sqlglot#faq
SQLFramehttps://github.com/eakmanrq/sqlframe
https://patch-diff.githubusercontent.com/cIark/sqlglot#examples
https://patch-diff.githubusercontent.com/cIark/sqlglot#formatting-and-transpiling
https://patch-diff.githubusercontent.com/cIark/sqlglot#metadata
ast primerhttps://github.com/tobymao/sqlglot/blob/main/posts/ast_primer.md
https://patch-diff.githubusercontent.com/cIark/sqlglot#parser-errors
https://patch-diff.githubusercontent.com/cIark/sqlglot#unsupported-errors
unsupported_levelhttps://github.com/tobymao/sqlglot/blob/b0e8dc96ba179edb1776647b5bde4e704238b44d/sqlglot/errors.py#L9
ruleshttps://github.com/tobymao/sqlglot/tree/main/sqlglot/optimizer
reach outhttps://patch-diff.githubusercontent.com/cIark/sqlglot#get-in-touch
https://patch-diff.githubusercontent.com/cIark/sqlglot#build-and-modify-sql
https://patch-diff.githubusercontent.com/cIark/sqlglot#sql-optimizer
techniqueshttps://github.com/tobymao/sqlglot/blob/main/sqlglot/optimizer/optimizer.py
https://patch-diff.githubusercontent.com/cIark/sqlglot#ast-introspection
https://patch-diff.githubusercontent.com/cIark/sqlglot#ast-diff
Semantic Diff for SQLhttps://github.com/tobymao/sqlglot/blob/main/posts/sql_diff.md
https://patch-diff.githubusercontent.com/cIark/sqlglot#custom-dialects
Dialectshttps://github.com/tobymao/sqlglot/tree/main/sqlglot/dialects
https://patch-diff.githubusercontent.com/cIark/sqlglot#sql-execution
Arrowhttps://arrow.apache.org/docs/index.html
Pandashttps://pandas.pydata.org/
Writing a Python SQL engine from scratchhttps://github.com/tobymao/sqlglot/blob/main/posts/python_sql_engine.md
https://patch-diff.githubusercontent.com/cIark/sqlglot#used-by
SQLMeshhttps://github.com/TobikoData/sqlmesh
Apache Supersethttps://github.com/apache/superset
Dagsterhttps://github.com/dagster-io/dagster
Fuguehttps://github.com/fugue-project/fugue
ibishttps://github.com/ibis-project/ibis
mysql-mimichttps://github.com/kelsin/mysql-mimic
Querybookhttps://github.com/pinterest/querybook
Quokkahttps://github.com/marsupialtail/quokka
Splinkhttps://github.com/moj-analytical-services/splink
SQLFramehttps://github.com/eakmanrq/sqlframe
https://patch-diff.githubusercontent.com/cIark/sqlglot#documentation
pdochttps://pdoc.dev/
SQLGlot websitehttps://sqlglot.com/
https://patch-diff.githubusercontent.com/cIark/sqlglot#run-tests-and-lint
https://patch-diff.githubusercontent.com/cIark/sqlglot#benchmarks
Benchmarkshttps://github.com/tobymao/sqlglot/blob/main/benchmarks/bench.py
https://patch-diff.githubusercontent.com/cIark/sqlglot#optional-dependencies
dateutilhttps://github.com/dateutil/dateutil
sqlglot.com/https://sqlglot.com/
Readme https://patch-diff.githubusercontent.com/cIark/sqlglot#readme-ov-file
MIT license https://patch-diff.githubusercontent.com/cIark/sqlglot#MIT-1-ov-file
Please reload this pagehttps://patch-diff.githubusercontent.com/cIark/sqlglot
Activityhttps://patch-diff.githubusercontent.com/cIark/sqlglot/activity
0 starshttps://patch-diff.githubusercontent.com/cIark/sqlglot/stargazers
0 watchinghttps://patch-diff.githubusercontent.com/cIark/sqlglot/watchers
0 forkshttps://patch-diff.githubusercontent.com/cIark/sqlglot/forks
Report repository https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2FcIark%2Fsqlglot&report=cIark+%28user%29
Releaseshttps://patch-diff.githubusercontent.com/cIark/sqlglot/releases
Packages 0https://patch-diff.githubusercontent.com/users/cIark/packages?repo_name=sqlglot
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.