Skip to content
Navigation Menu
Sign in
Products
Platform
GitHub
Repository hosting, code review, and collaboration
Copilot
AI coding agent for tasks, projects, and automated work
Build & Ship
Actions
CI/CD and automation
Code Quality
Quality analysis, fixes, and enforcement
Codespaces
Cloud development environments
Secure
Code Security
Vulnerability detection and remediation
Secret Protection
Secret scanning and leak prevention
All Features
Developers
Learn
Documentation
Training
Certifications
Build
Build with Copilot
Customize Copilot
Integrations
Explore
Trending repos
GitHub Sponsors
Developer articles
Changelog
Changelog
Your source for the latest features, improvements, and fixes across GitHub products, all in one place.
Businesses
By Stage
Enterprises
Team
Startups
Nonprofits
By Industry
Healthcare
Financial services
Manufacturing
Government
See all industries
Evaluate GitHub
Why GitHub
Customer Stories
Business insights
Trust Center
Add-ons
GitHub Advanced Security
Enterprise-grade code security
Copilot for business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Resources
Learn & Connect
Documentation
Resource center
Blog
Events & webinars
Community Forum
Customer Stories
Integrations
Support
Customer support
Training
GitHub Status
Company
About
Partners
Changelog
GitHub Universe
GitHub Universe
The event for developers, by developers — talks, workshops, and what’s next for GitHub.
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
removecode
sqlglot
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Files
Expand file tree
main
Breadcrumbs
sqlglot
/
tests
/
fixtures
/
optimizer
/
Copy path
Directory actions
More options
More options
Directory actions
More options
More options
Latest commit
History
History
History
main
Breadcrumbs
sqlglot
/
tests
/
fixtures
/
optimizer
/
Copy path
Top
Folders and files
Name
Name
Last commit message
Last commit date
parent directory
..
tpc-ds
tpc-ds
tpc-h
tpc-h
annotate_functions.sql
annotate_functions.sql
annotate_types.sql
annotate_types.sql
canonicalize.sql
canonicalize.sql
canonicalize_internal_names.sql
canonicalize_internal_names.sql
eliminate_ctes.sql
eliminate_ctes.sql
eliminate_joins.sql
eliminate_joins.sql
eliminate_subqueries.sql
eliminate_subqueries.sql
isolate_table_selects.sql
isolate_table_selects.sql
merge_subqueries.sql
merge_subqueries.sql
normalize.sql
normalize.sql
normalize_identifiers.sql
normalize_identifiers.sql
optimize_joins.sql
optimize_joins.sql
optimizer.sql
optimizer.sql
pushdown_cte_alias_columns.sql
pushdown_cte_alias_columns.sql
pushdown_predicates.sql
pushdown_predicates.sql
pushdown_projections.sql
pushdown_projections.sql
qualify_columns.sql
qualify_columns.sql
qualify_columns__invalid.sql
qualify_columns__invalid.sql
qualify_columns__with_invisible.sql
qualify_columns__with_invisible.sql
qualify_columns_ddl.sql
qualify_columns_ddl.sql
qualify_tables.sql
qualify_tables.sql
quote_identifiers.sql
quote_identifiers.sql
simplify.sql
simplify.sql
unnest_subqueries.sql
unnest_subqueries.sql
View all files
You can’t perform that action at this time.