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 }}
codeDing18
sqlglot
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Commits
Breadcrumbs
History for
sqlglot
sqlglot
dataframe
sql
functions.py
on
dev
User selector
All users
Datepicker
All time
Commit history
Commits on Mar 11, 2024
Fix: correctly generate ArrayJoin in various dialects (#3120)
Show description for c333017
georgesittas
authored
c333017
View commit details
Copy full SHA for c333017
View code at this point
Browse repository at this point
Commits on Feb 22, 2024
Feat: improve transpilation of Doris' MONTHS_ADD (#3012)
georgesittas
authored
d2e15ed
View commit details
Copy full SHA for d2e15ed
View code at this point
Browse repository at this point
Convert SIGNUM function to SIGN (#3007)
acreux
authored
9079ead
View commit details
Copy full SHA for 9079ead
View code at this point
Browse repository at this point
Commits on Feb 14, 2024
Fix(postgres): ensure json extraction can roundtrip unaltered (#2974)
georgesittas
authored
46f15ce
View commit details
Copy full SHA for 46f15ce
View code at this point
Browse repository at this point
Commits on Feb 9, 2024
chore: fix unit test
tobymao
committed
c4524ce
View commit details
Copy full SHA for c4524ce
View code at this point
Browse repository at this point
Commits on Jan 30, 2024
fix!: ignore nulls closes #2896 (#2898)
tobymao
authored
aa388ea
View commit details
Copy full SHA for aa388ea
View code at this point
Browse repository at this point
Commits on Jan 19, 2024
Feat: improve transpilation of Spark's TO_UTC_TIMESTAMP (#2861)
Show description for 326d3ae
georgesittas
authored
326d3ae
View commit details
Copy full SHA for 326d3ae
View code at this point
Browse repository at this point
Commits on Jan 4, 2024
Feat: improve transpilation of LAST_DAY (#2766)
Show description for a2abbc7
georgesittas
authored
a2abbc7
View commit details
Copy full SHA for a2abbc7
View code at this point
Browse repository at this point
Commits on Dec 26, 2023
refactor!: normalize units to all be upper case (#2714)
tobymao
authored
a4e899a
View commit details
Copy full SHA for a4e899a
View code at this point
Browse repository at this point
Commits on Dec 20, 2023
feat(optimizer): simplify date comparisons (#2710)
barakalon
authored
5624fdb
View commit details
Copy full SHA for 5624fdb
View code at this point
Browse repository at this point
Commits on Nov 14, 2023
Refactor!: get rid of SetAgg to use ArrayUniqueAgg for consistency (#2566)
Show description for 96d514c
georgesittas
authored
96d514c
View commit details
Copy full SHA for 96d514c
View code at this point
Browse repository at this point
Commits on Oct 24, 2023
Feat: add ArgMax, ArgMin expressions, fix their transpilation (#2454)
Show description for 64b18e6
georgesittas
authored
64b18e6
View commit details
Copy full SHA for 64b18e6
View code at this point
Browse repository at this point
Commits on Oct 17, 2023
Simplify Flatten expression
georgesittas
committed
ddab67d
View commit details
Copy full SHA for ddab67d
View code at this point
Browse repository at this point
Feat!(snowflake): add table alias for lateral FLATTEN calls (#2417)
Show description for 4e77be4
edpaget
authored
4e77be4
View commit details
Copy full SHA for 4e77be4
View code at this point
Browse repository at this point
Commits on Oct 10, 2023
Feat!: add explode outer and change hiearchy are explosions closes #2393
tobymao
committed
c7c3869
View commit details
Copy full SHA for c7c3869
View code at this point
Browse repository at this point
Commits on Oct 5, 2023
Feat(spark): from_utc_timestamp -> at time zone
tobymao
committed
ae27e46
View commit details
Copy full SHA for ae27e46
View code at this point
Browse repository at this point
Commits on Aug 14, 2023
Fix!(presto): transpile STRUCT(..) to ROW(..), introduce FIRST, LAST expressions (#2055)
Show description for 7a24679
georgesittas
authored
7a24679
View commit details
Copy full SHA for 7a24679
View code at this point
Browse repository at this point
Commits on Jul 27, 2023
Fix: trino->spark is_nan closes #1964
tobymao
committed
9787329
View commit details
Copy full SHA for 9787329
View code at this point
Browse repository at this point
Commits on Jul 20, 2023
Feat(hive): add support for the query TRANSFORM clause (#1935)
Show description for 1d2b5e0
georgesittas
authored
1d2b5e0
View commit details
Copy full SHA for 1d2b5e0
View code at this point
Browse repository at this point
Commits on Jul 18, 2023
Fix(spark,duckdb): transpile TO_TIMESTAMP, MONTHS_BETWEEN correctly (#1929)
Show description for e9f1cb5
georgesittas
authored
e9f1cb5
View commit details
Copy full SHA for e9f1cb5
View code at this point
Browse repository at this point
Commits on Jul 17, 2023
Feat: add RegexpReplace expression (#1925)
georgesittas
authored
3456bbf
View commit details
Copy full SHA for 3456bbf
View code at this point
Browse repository at this point
Commits on Jun 26, 2023
Feat(postgres): improve transpilation of ELEMENT_AT (#1830)
Show description for 5d5795d
georgesittas
authored
5d5795d
View commit details
Copy full SHA for 5d5795d
View code at this point
Browse repository at this point
Commits on May 8, 2023
Fix: base64 closes #1567
tobymao
committed
9f13b6c
View commit details
Copy full SHA for 9f13b6c
View code at this point
Browse repository at this point
Commits on Apr 30, 2023
Fix: tsql hashbytes closes #1508
tobymao
committed
2dcbc7f
View commit details
Copy full SHA for 2dcbc7f
View code at this point
Browse repository at this point
Commits on Apr 24, 2023
Fix(spark): refactor generation of DATE_SUB, add unit arg to df function (#1472)
georgesittas
authored
fd62d9d
View commit details
Copy full SHA for fd62d9d
View code at this point
Browse repository at this point
Commits on Mar 31, 2023
spark to_json fixes #1370
tobymao
committed
ed45b4b
View commit details
Copy full SHA for ed45b4b
View code at this point
Browse repository at this point
Commits on Feb 26, 2023
arrayjoin
tobymao
committed
199376b
View commit details
Copy full SHA for 199376b
View code at this point
Browse repository at this point
Commits on Feb 21, 2023
Export everything in __init__.py explicitly using aliases (#1207)
georgesittas
authored
1675201
View commit details
Copy full SHA for 1675201
View code at this point
Browse repository at this point
Commits on Feb 16, 2023
cleanup
tobymao
committed
a6da9ec
View commit details
Copy full SHA for a6da9ec
View code at this point
Browse repository at this point
Commits on Feb 6, 2023
Date funcs (#1104)
Show description for 80401dd
tobymao
and
cesarbruschetta
authored
80401dd
View commit details
Copy full SHA for 80401dd
View code at this point
Browse repository at this point
Commits on Feb 4, 2023
Fix transpilation of aggregate for presto (#1089)
georgesittas
authored
8671ac1
View commit details
Copy full SHA for 8671ac1
View code at this point
Browse repository at this point
Commits on Feb 2, 2023
postgres xor and power fixes #1074
tobymao
committed
dd2244e
View commit details
Copy full SHA for dd2244e
View code at this point
Browse repository at this point
Commits on Nov 18, 2022
Add support for HEX / UNHEX and ENCODE / DECODE to Presto and Spark (#726)
izeigerman
authored
661a140
View commit details
Copy full SHA for 661a140
View code at this point
Browse repository at this point
Commits on Nov 14, 2022
add canonicalize
tobymao
committed
169ba00
View commit details
Copy full SHA for 169ba00
View code at this point
Browse repository at this point
Commits on Nov 1, 2022
100 line length
tobymao
committed
fd7c55d
View commit details
Copy full SHA for fd7c55d
View code at this point
Browse repository at this point
Previous
Next
You can’t perform that action at this time.