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

#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

#3283 - Semicolon in t-sql - doesnt work with or without semicolon

Issue - State: closed - Opened by niatos99 6 months ago - 1 comment

#3281 - Revert "Chore: deploy sqlglot and then sqlglotrs"

Pull Request - State: closed - Opened by georgesittas 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

#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

#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

#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

#3258 - Feat(prql): Add support for TAKE

Pull Request - State: closed - Opened by fool1280 6 months ago

#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

#3253 - fix(mysql): Duplicate parsing of ENGINE_ATTRIBUTE

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

#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

#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

#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

#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

#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

#3202 - Unable to parse view definition with schemabinding

Issue - State: closed - Opened by mr-miles 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

#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

#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

#3184 - Adopting Substrait.io execution plans

Issue - State: closed - Opened by davlee1972 7 months ago - 4 comments