cmistiloglou

When writing a SQL query using MSSQL it does not recognize the `DECLARE` statement. Example: ```sql DECLARE @SpecifiedName NVARCHAR(10) = '%LEX%'; ``` The produced error: ``` ValueError: Not supported query...

I have the below sql query in MSSQL. ```sql SELECT ap.[AccountId], (SELECT COUNT(*) FROM [Transactions] t WHERE t.[AccountId] = ap.[AccountId]) AS TransactionCount FROM [AccountProfiles] ap ``` I am using the...

Using the method `parser.tables_aliases` it brings back `GROUP BY` as a table alias in MSSQL. ``` Tables Aliases: {'GROUP BY': '[Table1]', 't3': '[Table1]', 't4': '[Table2]', 't1': '[Table3]', 't2': '[Table4]'} ```...