Closed SawiSawaiz closed 11 months ago
Sub queries and CTE currently do not work for MS SQL dialect.
Example for Subquery.
query_1 = MSSQLQuery().from_(Table("xyz")).select("a") query_2 = MSSQLQuery().from_(query_1).select('*') print(str(query_2))
This throws an error "get_sql() got multiple values for keyword argument 'groupby_alias'" However, it works if I do not use SQL Server Dialect.
similarly CTE also do not work Example for CTE
query_1 = MSSQLQuery().from_(Table("xyz")).select("a") query_2 = MSSQLQuery().with_(query_1, "a").from_("a").select('*') print(str(query_2))
This throws also throws an error "get_sql() got multiple values for keyword argument 'groupby_alias'"
Sub queries and CTE currently do not work for MS SQL dialect.
Example for Subquery.
This throws an error "get_sql() got multiple values for keyword argument 'groupby_alias'" However, it works if I do not use SQL Server Dialect.
similarly CTE also do not work Example for CTE
This throws also throws an error "get_sql() got multiple values for keyword argument 'groupby_alias'"