Comments (5)
tobymao
commented on May 13, 2024
what dialect is exist? i'm not familiar with it
from sqlglot.
sasano8
commented on May 13, 2024
In my understanding, 'exists ' is a common operator in SQL.
Defined with at least SQL: 2011.
The following page is unofficial, but you can see the SQL specifications that comply with SQL: 2011.
https://en.wikibooks.org/wiki/Structured_Query_Language
The 'exists' clause takes a subquery as an argument.
https://en.wikibooks.org/wiki/Structured_Query_Language/Quantified_Comparison
from sqlglot.
tobymao
commented on May 13, 2024
this is now in v1.27.0
from sqlglot.
sasano8
commented on May 13, 2024
Thank you. It worked.
I'm trying out some SQL parsers.(sqlparse, moz_sql_parser) Among them, sqlglot feels great.
from sqlglot.
tobymao
commented on May 13, 2024
great!
from sqlglot.
Related Issues (20)
- Not all Snowflake date and time parts are properly supported
- percentile_cont is changed to quantile_cont (duckdb)
- lineage is broken when there is unnest
- CROSS APPLY is changed to LATERAL (tsql) HOT 3
- lineage is incorrect for 2 unnest HOT 3
- Convert SAMPLE (snowflake) to SAMPLE USING (duckdb) HOT 1
- Support TO_TIMESTAMP_* (Snowflake) HOT 1
- Support TIME (BigQuery) to TIME (duckdb) HOT 1
- timestamp_from_parts signature with date and time input arguments not supported (snowflake) HOT 1
- SAMPLE defaults when transpiling from Snowflake <-> duckdb
- Support BigQuery UNIX_DATE HOT 4
- Supports dialect conversion of statements after explain HOT 1
- `qualify` fails with `schema` HOT 3
- BigQuery does not parse COUNTIF HOT 1
- Support OBJECT_CONSTRUCT_KEEP_NULL (Snowflake)
- Tsql Exec command not parsed by sqlglot HOT 1
- nulls first/last transformation for mysql is incorrect in the context of `RANGE` windows HOT 5
- Linage results are not generated HOT 1
- Relation to SQLParser-rs HOT 1
- Support for SHOW SCHEMAS and SHOW OBJECTS (Snowflake) HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlglot.