sqlglot_sql_transpiling_between_dialects_and_pretty_printing.py

1import sqlglot
2
3# Transpile SQL from one dialect to another
4sql = "SELECT CAST(a AS INT) FROM x"
5transpiled = sqlglot.transpile(sql, read="duckdb", write="spark")[0]
6print(transpiled)
7# SELECT CAST(a AS INT) FROM x
8
9# Parse and format (pretty print) SQL
10sql = "SELECT left(x, 2), right(y, 3) FROM z"
11formatted = sqlglot.transpile(sql, read="duckdb", pretty=True)[0]
12print(formatted)
13# SELECT
14#   SUBSTR(x, 1, 2),
15#   SUBSTR(y, LENGTH(y) - 3 + 1, 3)
16# FROM z