The ShardingSphere SQL parser engine helps users to parse SQL to create the AST (Abstract Syntax Tree) and visit the AST to get SQLStatement (Java Object). Currently, we are planning to enhance the support for SQL Server SQL parsing in ShardingSphere.
SELECT BusinessEntityID
, DATEPART(QUARTER, QuotaDate) AS Quarter
, YEAR(QuotaDate) AS SalesYear
, SalesQuota AS QuotaThisQuarter
, SalesQuota - FIRST_VALUE(SalesQuota)
OVER (PARTITION BY BusinessEntityID, YEAR(QuotaDate)
ORDER BY DATEPART(QUARTER, QuotaDate)) AS DifferenceFromFirstQuarter
, SalesQuota - LAST_VALUE(SalesQuota)
OVER (PARTITION BY BusinessEntityID, YEAR(QuotaDate)
ORDER BY DATEPART(QUARTER, QuotaDate)
RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) AS DifferenceFromLastQuarter
FROM Sales.SalesPersonQuotaHistory
WHERE YEAR(QuotaDate) > 2005 AND BusinessEntityID BETWEEN 274 AND 275
ORDER BY BusinessEntityID, SalesYear, Quarter
Background
Hi community. This issue is for #29149.
The ShardingSphere SQL parser engine helps users to parse SQL to create the AST (Abstract Syntax Tree) and visit the AST to get SQLStatement (Java Object). Currently, we are planning to enhance the support for
SQL Server
SQL parsing in ShardingSphere.More details: https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/
Task
This issue is to support more
SQL Server
sql parsing, as follows:link
link
link
link
link
Process
SQL Server
sql syntax, if not please leave a message under the issue and ignore it;Relevant Skills
g4
fileSQL Server
SQLs