Transpiling a CREATE TABLE ... LIKE ... statement to DuckDB does not use the existing DuckDB syntax

[tharwan]

Fully reproducible code snippet

import sqlglot

sqlglot.transpile("CREATE TABLE t2 LIKE t1", read="snowflake", write="duckdb")

Official Documentation
https://duckdb.org/docs/sql/statements/create_table.html

While DuckDB does not support the LIKE property, but the same can be expressed with:

CREATE TABLE t2 AS FROM t1 LIMIT 0;

[georgesittas]

Thanks, will take a look shortly.