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
#3289 - fix!: allow to_column to properly parse quoted column paths, make typ…
Pull Request -
State: closed - Opened by tobymao 6 months ago
#3288 - Hive. Insert statement failure.
Issue -
State: closed - Opened by bkyryliuk 6 months ago
- 3 comments
#3287 - Presto. Qualify alias name is treated as a special expression
Issue -
State: closed - Opened by bkyryliuk 6 months ago
- 4 comments
#3286 - GROUP BY DISTINCT fails when parsing presto query
Issue -
State: closed - Opened by bkyryliuk 6 months ago
#3285 - Duplicated empty alias when traversing the scope
Issue -
State: closed - Opened by bkyryliuk 6 months ago
- 2 comments
#3284 - feat(snowflake): FINAL/RUNNING keywords in MATCH_RECOGNIZE MEASURES
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3283 - Semicolon in t-sql - doesnt work with or without semicolon
Issue -
State: closed - Opened by niatos99 6 months ago
- 1 comment
#3282 - Support FINAL/RUNNING specifier for measures in match_recognize (Snowflake)
Issue -
State: closed - Opened by galunto 6 months ago
#3281 - Revert "Chore: deploy sqlglot and then sqlglotrs"
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3280 - sqlglot.parse throws a ParseError when encountering 'DESC HISTORY table_name' when reading Databricks dialect
Issue -
State: closed - Opened by ericvergnaud 6 months ago
#3279 - Invalid datediff when converting from presto to spark
Issue -
State: closed - Opened by williaster 6 months ago
- 3 comments
#3278 - Fix(optimizer): unnest union subqueries
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3277 - Feat!: transpile map retrieval to duckdb, transpile TRY_ELEMENT_AT
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3276 - 'Union' object has no attribute 'group_by'
Issue -
State: closed - Opened by khabiri 6 months ago
#3275 - feat(clickhouse): column constraints
Pull Request -
State: closed - Opened by pkit 6 months ago
- 3 comments
#3274 - Sybase TSQL Support
Issue -
State: closed - Opened by davlee1972 6 months ago
- 3 comments
#3273 - Fix(optimizer): preserve the original type when creating a date literal
Pull Request -
State: closed - Opened by georgesittas 6 months ago
- 3 comments
#3272 - Fix!(mysql): parse wrapped ordered for KEY/INDEX constraint
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3271 - ASC/DESC index not supported "ParseError: Expecting )."
Issue -
State: closed - Opened by anentropic 6 months ago
#3270 - fix(optimizer): tweaks to date simplification
Pull Request -
State: closed - Opened by barakalon 6 months ago
#3269 - Fix: amend interval unit parsing regression
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3268 - Interval parsing on postgres broken since 23.4.0
Issue -
State: closed - Opened by LilyFoote 6 months ago
- 1 comment
#3267 - fix: allow placeholders in units closes #3265
Pull Request -
State: closed - Opened by tobymao 6 months ago
#3266 - Invalid subquery order converting from presto to spark
Issue -
State: closed - Opened by williaster 6 months ago
- 5 comments
#3265 - generated `date_trunc` calls do not preserve placeholders for part argument
Issue -
State: closed - Opened by dylanscott 6 months ago
#3264 - Chore: deploy sqlglot and then sqlglotrs
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3263 - Running "optimize" with only merge_subqueries rule results in wrong SQL
Issue -
State: closed - Opened by daniel769 6 months ago
- 7 comments
#3261 - fix: Fix STRPOS for Presto & Trino
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3260 - Concurrent deadlock
Issue -
State: closed - Opened by grieve54706 6 months ago
- 1 comment
#3259 - Converstion of snowflake POSITION to Trino STRPOS Is incorrect
Issue -
State: closed - Opened by amitgilad3 6 months ago
#3258 - Feat(prql): Add support for TAKE
Pull Request -
State: closed - Opened by fool1280 6 months ago
#3257 - bug(snowflake): error in second-pass of `add_within_group_for_percentiles`
Issue -
State: closed - Opened by gforsyth 6 months ago
- 3 comments
#3256 - Fix!: properly transpile escape sequences
Pull Request -
State: closed - Opened by georgesittas 6 months ago
- 2 comments
#3255 - feat(snowflake): MATCH_CONDITION in ASOF JOIN
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3254 - `MATCH_CONDITION` not recognised in `ASOF JOIN` for Snowflake
Issue -
State: closed - Opened by Bilbottom 6 months ago
#3253 - fix(mysql): Duplicate parsing of ENGINE_ATTRIBUTE
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3252 - feat(clickhouse): CREATE TABLE computed columns, column compression, index
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3251 - `DATETIME` `parse_one` using BigQuery dialect is incorrect
Issue -
State: closed - Opened by cpcloud 6 months ago
- 3 comments
#3250 - docs: Rename Superset to Apache Superset
Pull Request -
State: closed - Opened by john-bodley 6 months ago
#3249 - In certain dialects, `schema` is not respected when supplied to `optimize`
Issue -
State: closed - Opened by rexledesma 6 months ago
- 1 comment
#3248 - Parser fails when processing spark hint in databricks dialect
Issue -
State: closed - Opened by bkyryliuk 6 months ago
#3247 - Unable to parse Trino statement with non-escaped limit column
Issue -
State: closed - Opened by john-bodley 6 months ago
- 12 comments
#3246 - Presto. Failed to parse interval expression
Issue -
State: closed - Opened by bkyryliuk 6 months ago
#3245 - feat: add conversion of named tuples and classes to structs
Pull Request -
State: closed - Opened by tobymao 6 months ago
#3244 - Unable to parse DESCRIBE FORMATTED Hive statements
Issue -
State: closed - Opened by john-bodley 6 months ago
#3243 - Extend support CREATE TABLE statement for clickhouse
Issue -
State: closed - Opened by lksv 6 months ago
#3242 - Feat: mvp for transpling sqlite's STRFTIME
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3241 - Fix: properly parse/generate duckdb MAP {..} syntax, annotate MAPs
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3240 - DuckDB STRFTIME arguments incorrectly ordered
Issue -
State: closed - Opened by markhalonen 6 months ago
#3239 - Snowflake FETCH exception during Plan
Issue -
State: closed - Opened by brentonmallen1 6 months ago
- 5 comments
#3238 - feat(oracle): Support for CONNECT BY [NOCYCLE]
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3237 - Oracle queries with keyword NOCYCLE not supported in CONNECT BY NOCYCLE PRIOR
Issue -
State: closed - Opened by Hal-H2Apps 6 months ago
#3236 - Error when parsing query with > = or < = operator with a space between < and =
Issue -
State: closed - Opened by Hal-H2Apps 6 months ago
- 6 comments
#3234 - feat(optimizer): Support for small integer CAST elimination
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
- 6 comments
#3233 - Fix: don't evaluate Rand twice when ordering by it
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3232 - Transpiling RANDOM order by between dialects
Issue -
State: closed - Opened by johannesboyne 6 months ago
- 11 comments
#3231 - Crash during an oracle query parsing. The query is working fine when running on the DB.
Issue -
State: closed - Opened by Hal-H2Apps 6 months ago
- 4 comments
#3230 - Fix: make property value parsing more lenient
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3229 - feature: optimizer: statically analyze conditions to check for literals
Issue -
State: closed - Opened by NickCrews 6 months ago
- 11 comments
#3228 - bigquery options timestamp
Issue -
State: closed - Opened by hsheth2 6 months ago
#3226 - Fix(optimizer): constrain UDTF scope boundary
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3225 - Fix!: StrToUnix Hive parsing, Presto generation fixes
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3224 - feat(optimizer): Support for UNION BY NAME
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3223 - feat: Support for MySQL & Redshift UnixTotime
Pull Request -
State: closed - Opened by VaggelisD 6 months ago
#3222 - Incorrect optimized SQL.
Issue -
State: closed - Opened by yiyuanliu 6 months ago
#3221 - unix_timestamp() is Error
Issue -
State: closed - Opened by luhea 6 months ago
- 1 comment
#3220 - fix: bq datetime to timestamp
Pull Request -
State: closed - Opened by eakmanrq 6 months ago
#3219 - Question. How to collapse AND or OR expression.
Issue -
State: closed - Opened by davlee1972 6 months ago
- 2 comments
#3218 - Provide broad support for the SHOW COLUMNS statement
Issue -
State: closed - Opened by john-bodley 6 months ago
- 1 comment
#3217 - Add DNF syntax support to exp.where()
Issue -
State: closed - Opened by davlee1972 6 months ago
- 7 comments
#3216 - Add date support for tsql dialect
Issue -
State: closed - Opened by davlee1972 6 months ago
#3215 - fix(optimizer): don't merge ORDER BY into UNION
Pull Request -
State: closed - Opened by barakalon 6 months ago
#3214 - function from_unixtime trans error
Issue -
State: closed - Opened by exgalibas 6 months ago
#3213 - Fix(snowflake): convert VALUES with invalid expressions into UNION ALL
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3212 - Feat(duckdb): add support for heredoc string syntax
Pull Request -
State: closed - Opened by georgesittas 6 months ago
#3211 - Optimize Function does not seem to deal with ORDER BY in CTEs
Issue -
State: closed - Opened by rorynormaness 6 months ago
- 2 comments
#3209 - Invalid SQL output from optimize function
Issue -
State: closed - Opened by rorynormaness 6 months ago
- 1 comment
#3206 - Trino - `SORT BY` gets removed:
Issue -
State: closed - Opened by dmelchor-stripe 7 months ago
- 1 comment
#3205 - `SORT BY` gets removed
Issue -
State: closed - Opened by dmelchor-stripe 7 months ago
- 4 comments
#3204 - Fix(tokenizer): don't increment array cursor by 2 on CRLF
Pull Request -
State: closed - Opened by georgesittas 7 months ago
- 2 comments
#3203 - Feat!(tsql): add support for WITH <view_attribute> in view DDL
Pull Request -
State: closed - Opened by georgesittas 7 months ago
#3202 - Unable to parse view definition with schemabinding
Issue -
State: closed - Opened by mr-miles 7 months ago
#3201 - Fix(generator): compute csv leading comma pad length correctly
Pull Request -
State: closed - Opened by georgesittas 7 months ago
#3200 - Windows line endings cause IndexOutOfRange during tokenization
Issue -
State: closed - Opened by mr-miles 7 months ago
- 4 comments
#3199 - Inconsistent formatting when leading_comma=True
Issue -
State: closed - Opened by giovannipcarvalho 7 months ago
- 1 comment
#3198 - Feat: add support for converting `bytes` to sqlglot AST
Pull Request -
State: closed - Opened by georgesittas 7 months ago
#3197 - ClickHouse: fail to qualify "WITH <expression> AS <identifier>"
Issue -
State: closed - Opened by herry13 7 months ago
- 6 comments
#3196 - date_trunc for Athena/Trino incorrectly truncates
Issue -
State: closed - Opened by rubytobi 7 months ago
- 1 comment
#3195 - ex.convert(b"\x00\x00\x00\x00\x00\x00\x07\xd3") throws, but should be HexString
Issue -
State: closed - Opened by aersam 7 months ago
- 2 comments
#3194 - feat: redshift starts with support
Pull Request -
State: closed - Opened by eakmanrq 7 months ago
#3193 - Add more Snowflake aggregate functions
Pull Request -
State: closed - Opened by ttzhou 7 months ago
- 3 comments
#3192 - Refactor: get rid of redundant condition in Expression.replace
Pull Request -
State: closed - Opened by georgesittas 7 months ago
#3191 - fix(postgres): Fix ARROW/DARROW column operators
Pull Request -
State: closed - Opened by VaggelisD 7 months ago
#3190 - fix: Fix backtracking through try/catch exceptions
Pull Request -
State: closed - Opened by VaggelisD 7 months ago
#3189 - feat(mysql): Parse MODIFY COLUMN
Pull Request -
State: closed - Opened by VaggelisD 7 months ago
#3188 - Clickhouse: ARRAY JOIN clause treated as a table join
Issue -
State: closed - Opened by smoothml 7 months ago
- 2 comments
#3187 - Parsing does not fail on invalid syntax queries
Issue -
State: closed - Opened by dlahyani 7 months ago
- 1 comment
#3186 - MySQL: Parsing ALTER TABLE ... MODIFY not parsed as exp.AlterTable
Issue -
State: closed - Opened by kosti-hokkanen-supermetrics 7 months ago
- 3 comments
#3185 - Fails to produce SQL representation of transformed tree when a JSON key has a `-`
Issue -
State: closed - Opened by ZipBrandon 7 months ago
- 1 comment
#3184 - Adopting Substrait.io execution plans
Issue -
State: closed - Opened by davlee1972 7 months ago
- 4 comments