Ecosyste.ms: Issues
An open API service for providing issue and pull request metadata for open source projects.
GitHub / tobymao/sqlglot issues and pull requests
#3360 - Fix(lineage): use source names of derived table sources for laterals
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3359 - feat: COPY TO/FROM statement
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
- 1 comment
#3358 - Fix: export optimizer functions explicitly in init
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3357 - Fix(postgres): don't generate CommentColumnConstraint
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3356 - No `source_name` in column lineage with `LATERAL FLATTEN`
Issue -
State: closed - Opened by eliaperantoni 2 months ago
#3355 - fix: export optimize
Pull Request -
State: closed - Opened by tekumara 2 months ago
- 1 comment
#3354 - "optimize" is not exported from module "sqlglot.optimizer"
Issue -
State: closed - Opened by tekumara 2 months ago
- 2 comments
#3353 - DESCRIBE expressions throw ParseError (duckdb)
Issue -
State: closed - Opened by tekumara 2 months ago
#3352 - fix(duckdb)!: Combine aggregate functions with orderby from WITHIN GROUP
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
#3351 - feat(Vertica): Add Vertica dialect
Pull Request -
State: closed - Opened by Rajasekhar-Vuppala 2 months ago
#3350 - snowflake -> duckdb ordered listagg transpilation error
Issue -
State: closed - Opened by btyuhas 2 months ago
#3349 - [feature request] Support Trino FUNCTION declaration
Issue -
State: closed - Opened by kevinjqliu 2 months ago
- 1 comment
#3348 - fix(tsql): Convert TIMESTAMP to ROWVERSION, transpile both to BINARY
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
#3347 - feat(clickhouse): Parse window functions in ParameterizedAggFuncs
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
#3346 - Python Executor - ROW_NUMBER() function raises ExecuteError
Issue -
State: closed - Opened by rubytobi 2 months ago
- 1 comment
#3345 - SQL Server Rowversion/Timestamp not parsed correctly
Issue -
State: closed - Opened by aersam 2 months ago
- 1 comment
#3344 - ParseError when handling valid ClickHouse SQL with quantileGK and window functions
Issue -
State: closed - Opened by alesk 2 months ago
#3343 - Feat(prql): add support for AGGREGATE
Pull Request -
State: closed - Opened by fool1280 2 months ago
#3342 - Fix(tsql): only use target table name when generating sp_rename
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3341 - Feat: parse (a,) as a tuple instead of a paren
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3340 - Feat: allow comments to be attached for identifiers used in definitions
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3339 - Fix!(snowflake): improve transpilability of [TO_]DATE(x)
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3338 - duckdb: non-literal date is no longer cast as date when converted from snowflake
Issue -
State: closed - Opened by tekumara 2 months ago
#3337 - Sqlglot does not preserve Snowflake comments format and merges them into one line
Issue -
State: closed - Opened by baruchoxman 3 months ago
- 1 comment
#3336 - sqlglot cannot recognize/parse column name which starts with a number
Issue -
State: closed - Opened by xinglin-zhao 3 months ago
- 8 comments
#3335 - Conjunction precedence issue: and/or evaluation order
Issue -
State: closed - Opened by anil-panicker 3 months ago
- 1 comment
#3334 - fix ApproxDistinct snowflake transpilation
Pull Request -
State: closed - Opened by ajendrex 3 months ago
- 2 comments
#3333 - fix: allow bigquery udf with resered keyword closes #3332
Pull Request -
State: closed - Opened by tobymao 3 months ago
#3332 - User defined functions with reserved keyword names raise ParseError in BigQuery dialect
Issue -
State: closed - Opened by sean-rose 3 months ago
#3331 - Feat(prql): handle NULL
Pull Request -
State: closed - Opened by fool1280 3 months ago
#3330 - Fix!(bigquery): parse multiple quoted table parts in columns correctly
Pull Request -
State: closed - Opened by georgesittas 3 months ago
- 1 comment
#3329 - feat(clickhouse): Add support for DATE_FORMAT / formatDateTime
Pull Request -
State: closed - Opened by VaggelisD 3 months ago
- 1 comment
#3328 - BigQuery: `*` turns into `6` in PARSE_TIMESTAMP format string
Issue -
State: closed - Opened by schmee-td 3 months ago
- 1 comment
#3327 - feat!: Introduce partition in exp.Table
Pull Request -
State: closed - Opened by VaggelisD 3 months ago
#3326 - feat(hive): Add 'STORED AS' option in INSERT DIRECTORY
Pull Request -
State: closed - Opened by VaggelisD 3 months ago
#3325 - feat(Vertica): Add Vertica Dialect
Pull Request -
State: closed - Opened by Rajasekhar-Vuppala 3 months ago
- 3 comments
#3324 - Wrong Convert for 'DATE_FORMAT' between mysql and clickhouse.(TIME_TO_STR)
Issue -
State: closed - Opened by PaienNate 3 months ago
#3323 - Hive's CREATE TABLE SQL comments and storage format in the output of statement are formatted incorrectly.
Issue -
State: closed - Opened by PaienNate 3 months ago
- 3 comments
#3322 - feat!: add comprehensive reserved keywords for presto and redshift
Pull Request -
State: closed - Opened by tobymao 3 months ago
#3321 - Improper parsing Teradata Analytic Functions
Issue -
State: closed - Opened by lorr1 3 months ago
- 2 comments
#3320 - Parsing of insert overwrite directory fails in hive dialect
Issue -
State: closed - Opened by bkyryliuk 3 months ago
#3319 - Hive. Query parsing fails when column is named application for insert overwrite partition
Issue -
State: closed - Opened by bkyryliuk 3 months ago
- 1 comment
#3318 - Unable to resolve columns when using BigQuery's alternate table identifier quoting
Issue -
State: closed - Opened by ravi77o 3 months ago
- 2 comments
#3317 - fix(optimizer)!: Preserve DPipe in simplify_concat
Pull Request -
State: closed - Opened by VaggelisD 3 months ago
- 2 comments
#3316 - feat: allow qualify to also annotate on the fly for unnest support
Pull Request -
State: closed - Opened by tobymao 3 months ago
#3315 - Fix(optimizer): don't simplify parentheses when parent is SubqueryPredicate
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3314 - Fix(redshift): unqualify unnest columns
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3313 - Optimize and remove left joins
Issue -
State: closed - Opened by wesley-too 3 months ago
- 1 comment
#3312 - "NOT BETWEEN" not supported
Issue -
State: closed - Opened by LoganDark 3 months ago
- 5 comments
#3311 - Create view statement generation misses table name if catalog is specified
Issue -
State: closed - Opened by nfx 3 months ago
- 5 comments
#3310 - string escaping is incorrect for mysql
Issue -
State: closed - Opened by cpcloud 3 months ago
- 7 comments
#3309 - Feat(optimizer): improve qualification logic for unnested structs in bigquery
Pull Request -
State: closed - Opened by georgesittas 3 months ago
- 1 comment
#3308 - Refactor: get rid of 1st projection pad for leading comma formatting
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3307 - Fix: transform eliminate_qualify on generated columns
Pull Request -
State: closed - Opened by viplazylmht 3 months ago
- 4 comments
#3306 - Feat(bigquery): handle more extract parts
Pull Request -
State: closed - Opened by maureen-daum 3 months ago
#3305 - Fix: Add postgres transpilation for TIME_TO_UNIX
Pull Request -
State: closed - Opened by crericha 3 months ago
#3304 - Fix!: parse right-hand side of <value> IN (<query>) as a Subquery
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3303 - Feat(teradata): handle transpile of quarter function
Pull Request -
State: closed - Opened by maureen-daum 3 months ago
#3302 - Fix!: cast less aggressively
Pull Request -
State: closed - Opened by georgesittas 3 months ago
- 3 comments
#3301 - feat!: allow unions to be limited directly and stop subquerying since…
Pull Request -
State: closed - Opened by tobymao 3 months ago
#3300 - Solving: 'Union' object has no attribute 'order_by'
Issue -
State: closed - Opened by williaster 3 months ago
- 2 comments
#3299 - Feat(prql): Handle DESC with sort
Pull Request -
State: closed - Opened by fool1280 3 months ago
#3298 - order of logical operation is not interpreted correctly
Issue -
State: closed - Opened by khabiri 3 months ago
- 4 comments
#3297 - Feat(prql): Add support for SORT
Pull Request -
State: closed - Opened by fool1280 3 months ago
#3296 - Teradata datetime functions
Issue -
State: closed - Opened by maureen-daum 3 months ago
- 1 comment
#3295 - Feat: improve transpilation of datetime functions to Teradata
Pull Request -
State: closed - Opened by maureen-daum 3 months ago
- 2 comments
#3294 - Fix(optimizer): propagate recursive CTE source to children scopes early
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3293 - Feat(postgres): add COMMENT ON MATERIALIZED VIEW
Pull Request -
State: closed - Opened by l-vincent-l 3 months ago
#3292 - Fix: make exp.to_column more lenient
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3291 - Feat(prql): Add FILTER
Pull Request -
State: closed - Opened by fool1280 3 months ago
- 2 comments
#3290 - Feat(presto): add support for DISTINCT / ALL after GROUP BY
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3289 - fix!: allow to_column to properly parse quoted column paths, make typ…
Pull Request -
State: closed - Opened by tobymao 3 months ago
#3288 - Hive. Insert statement failure.
Issue -
State: closed - Opened by bkyryliuk 3 months ago
- 3 comments
#3287 - Presto. Qualify alias name is treated as a special expression
Issue -
State: closed - Opened by bkyryliuk 3 months ago
- 4 comments
#3286 - GROUP BY DISTINCT fails when parsing presto query
Issue -
State: closed - Opened by bkyryliuk 3 months ago
#3285 - Duplicated empty alias when traversing the scope
Issue -
State: closed - Opened by bkyryliuk 3 months ago
- 2 comments
#3284 - feat(snowflake): FINAL/RUNNING keywords in MATCH_RECOGNIZE MEASURES
Pull Request -
State: closed - Opened by VaggelisD 3 months ago
#3283 - Semicolon in t-sql - doesnt work with or without semicolon
Issue -
State: closed - Opened by niatos99 3 months ago
- 1 comment
#3282 - Support FINAL/RUNNING specifier for measures in match_recognize (Snowflake)
Issue -
State: closed - Opened by galunto 3 months ago
#3281 - Revert "Chore: deploy sqlglot and then sqlglotrs"
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3280 - sqlglot.parse throws a ParseError when encountering 'DESC HISTORY table_name' when reading Databricks dialect
Issue -
State: closed - Opened by ericvergnaud 3 months ago
#3279 - Invalid datediff when converting from presto to spark
Issue -
State: closed - Opened by williaster 3 months ago
- 3 comments
#3278 - Fix(optimizer): unnest union subqueries
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3277 - Feat!: transpile map retrieval to duckdb, transpile TRY_ELEMENT_AT
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3276 - 'Union' object has no attribute 'group_by'
Issue -
State: closed - Opened by khabiri 3 months ago
#3275 - feat(clickhouse): column constraints
Pull Request -
State: closed - Opened by pkit 3 months ago
- 3 comments
#3274 - Sybase TSQL Support
Issue -
State: closed - Opened by davlee1972 3 months ago
- 3 comments
#3273 - Fix(optimizer): preserve the original type when creating a date literal
Pull Request -
State: closed - Opened by georgesittas 3 months ago
- 3 comments
#3272 - Fix!(mysql): parse wrapped ordered for KEY/INDEX constraint
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3271 - ASC/DESC index not supported "ParseError: Expecting )."
Issue -
State: closed - Opened by anentropic 3 months ago
#3270 - fix(optimizer): tweaks to date simplification
Pull Request -
State: closed - Opened by barakalon 3 months ago
#3269 - Fix: amend interval unit parsing regression
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3268 - Interval parsing on postgres broken since 23.4.0
Issue -
State: closed - Opened by LilyFoote 3 months ago
- 1 comment
#3267 - fix: allow placeholders in units closes #3265
Pull Request -
State: closed - Opened by tobymao 3 months ago
#3266 - Invalid subquery order converting from presto to spark
Issue -
State: closed - Opened by williaster 3 months ago
- 5 comments
#3265 - generated `date_trunc` calls do not preserve placeholders for part argument
Issue -
State: closed - Opened by dylanscott 3 months ago
#3264 - Chore: deploy sqlglot and then sqlglotrs
Pull Request -
State: closed - Opened by georgesittas 3 months ago
#3263 - Running "optimize" with only merge_subqueries rule results in wrong SQL
Issue -
State: closed - Opened by daniel769 3 months ago
- 7 comments
#3261 - fix: Fix STRPOS for Presto & Trino
Pull Request -
State: closed - Opened by VaggelisD 3 months ago
#3260 - Concurrent deadlock
Issue -
State: closed - Opened by grieve54706 3 months ago
- 1 comment