Archonic
Archonic
If I use `Transact-SQL` it no longer has a problem with the `[]` characters but errors on `{d'2024-01` later on in my statement.
Thanks for clearing that up. Here's a full example: ``` WITH [ContactCustomer_VW_d1c5f9_base_query] AS ( SELECT [Segments].[GL_Sys].[ContactCustomer_VW].[D_Customersid] AS [D_Customersid], [Segments].[GL_Sys].[ContactCustomer_VW].contactid AS contactid FROM [Segments].[GL_Sys].[ContactCustomer_VW] ), [ProductPLineMCPLineVendor_VW_1cc5f5_base_query] AS ( SELECT [Segments].[GL_Sys].[ProductPLineMCPLineVendor_VW].[D_Products__D_Productsid] AS...
Yes, it's supported natively: https://learn.microsoft.com/en-us/sql/t-sql/data-types/date-transact-sql?view=sql-server-ver17#odbc-date-format
Let me know if there's anything I can do to help here. I may have time today to try my hand at supporting this syntax.