[REVENG] Unblock scaffolding of Azure SQL DW

[ErikEJ]

See discussion here: #15438 (comment)
//cc @bricelam

[ErikEJ]

SELECT
    SCHEMA_NAME([t].[schema_id]) AS [table_schema],
    [t].[name] AS [table_name],
    [c].[name] AS [column_name],
    [c].[column_id] AS [ordinal],
    SCHEMA_NAME([tp].[schema_id]) AS [type_schema],
    [tp].[name] AS [type_name],
    CAST([c].[max_length] AS int) AS [max_length],
    CAST([c].[precision] AS int) AS [precision],
    CAST([c].[scale] AS int) AS [scale],
    [c].[is_nullable],
    [c].[is_identity],
    OBJECT_DEFINITION([c].[default_object_id]) AS [default_sql],
    [df].[definition] AS [default_sql2],
    [cc].[definition] AS [computed_sql]
FROM [sys].[columns] AS [c]
JOIN [sys].[tables] AS [t] ON [c].[object_id] = [t].[object_id]
JOIN [sys].[types] AS [tp] ON [c].[user_type_id] = [tp].[user_type_id]
LEFT JOIN [sys].[computed_columns] AS [cc] ON [c].[object_id] = [cc].[object_id] AND [c].[column_id] = [cc].[column_id]
LEFT JOIN [sys].[default_constraints] AS [df] ON [c].[object_id] = [df].[parent_object_id] AND [df].[parent_column_id] = [c].[column_id]