SqlScriptDOM
SqlScriptDOM copied to clipboard
microsoft
ScriptDOM/SqlDOM is a .NET library for parsing T-SQL statements and interacting with its abstract syntax tree
Repro: ```sql SELECT CAST ($492050157978986.2129 AS MONEY) AS [p_0_0] FROM ([dbo].[table_6] AS [alias_0_0] CROSS JOIN [dbo].[table_4] AS [alias_0_1]) WHERE (NOT (SYSDATETIME() IN (SELECT @Var39 AS [p_1_0] FROM ([dbo].[table_0] AS [alias_1_0]...
We have encountered a parsing issue in [Microsoft Documentation](https://learn.microsoft.com/en-us/sql/t-sql/functions/json-objectagg-transact-sql?view=sql-server-ver17#examples) in `JSON_OBJECTAGG` using TSql170Parser [170.128.0](https://www.nuget.org/packages/Microsoft.SqlServer.TransactSql.ScriptDom/170.128.0). **Example script** ``` SELECT JSON_OBJECTAGG( t.c1 : t.c2 ) FROM ( VALUES('key1', 'c'), ('key2', 'b'), ('key3','a')...
#### Version - `170.128.0` #### Parser - TSql170Parser `JSON_OBJECT` when inside `RETURN` statement does not get parsed with above mentioned parser version and details. ### Steps to reproduce - Try...
We have encountered a parsing issue in [Microsoft Documentation for MS Fabric Query Hints](https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=fabric&preserve-view=true#examples) using TSql170Parser [170.128.0](https://www.nuget.org/packages/Microsoft.SqlServer.TransactSql.ScriptDom/170.128.0). **Examples** [FOR TIMESTAMP AS OF](https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=fabric&preserve-view=true#o-query-data-as-of-a-point-in-time) ``` SELECT OrderDateKey, SUM(SalesAmount) AS TotalSales FROM FactInternetSales...
We have encountered a parsing issue in [Microsoft Documentation](https://learn.microsoft.com/en-us/sql/t-sql/statements/copy-into-transact-sql?view=fabric&preserve-view=true#b-load-authenticating-via-share-access-signature-sas-1) in COPY INTO using TSql170Parser [170.128.0](https://www.nuget.org/packages/Microsoft.SqlServer.TransactSql.ScriptDom/170.128.0). #### Example script ``` COPY INTO test_1 FROM 'https://myaccount.blob.core.windows.net/myblobcontainer/folder1/' WITH ( FILE_TYPE = 'CSV', CREDENTIAL=(IDENTITY=...
# Description Introduced IdentifierCasing option enabling upper / lower / pascal-casing of all identifiers in `ScriptWriter`. Resolves #177. `SqlScriptGeneratorOptions` now supports a new setting `IdentifierCasing` with the following options: -...
SQL Server compares identifiers with respect to the CI/CS, AI/AS setting of the respective database's collation. While accent sensitivity has no effect on the SQL source code, case-sensitivity _may_ have...
### Description While using the Microsoft ScriptDom parser, I observed an inconsistency in the classification of properties within the `CreateExternalModelStatement` class. Most properties are correctly identified as `TSqlFragment` types, including:...
# Description resolves #20 enables the code formatter to preserve T-SQL comments, including ```sql -- comments leading any T-SQL /* comments that span multiple lines */ -- single line comments...
I was redirected here to create this issue from: https://github.com/madskristensen/SqlFormatter/issues/24 # Original request **Is your feature request related to a problem? Please describe.** My team standardizes on commas being placed...
