Postgres DDL to Clickhouse converter

dump.sql

select
    concat(
        'create table ',
        table_name,
        '(',
        string_agg(
                concat(
                        column_name,
                        ' ',
                        CASE when is_nullable = 'YES' THEN 'Nullable(' END,
                        CASE
                            when data_type = 'integer' then 'Int32'
                            when data_type = 'smallint' then 'Int16'
                            when data_type = 'bigint' then 'Int64'
                            when data_type = 'numeric'
                                then concat('Decimal64(12)')
                            when data_type = 'double precision' then 'Float64'
                            when data_type = 'character varying' then 'String'
                            when data_type = 'character' then 'String'
                            when data_type = 'text' then 'String'
                            when data_type = 'boolean' then 'UInt8'
                            when data_type = 'date' then 'Date'
                            when data_type = 'timestamp without time zone' then 'Datetime'
                            when data_type = 'timestamp with time zone' then 'Datetime'
                            when data_type = 'time without time zone' then 'String'
                            when data_type = 'uuid' then 'UUID'
                            when data_type = 'json' then 'TEXT'
                            else concat('###################', data_type)
                            END,
                        CASE when is_nullable = 'YES' THEN ')' END
                    ),
                ', ' order by ordinal_position
        ),
        ') ',
        'ENGINE = MergeTree() '
        'PARTITION BY id '
        'ORDER BY [id] '
    ) as table_ddl
from information_schema.columns
where true
  and table_schema = 'public'
  and table_name = 'raw_logs'
group by table_name;