Convert Parquet to SQL

How to do it manually

DuckDB → SQL dump

DuckDB can read a .parquet file and emit standard SQL inserts:

duckdb my.db <<EOF
CREATE TABLE orders AS SELECT * FROM 'data.parquet';
.mode insert orders
SELECT * FROM orders;
EOF

PostgreSQL via pandas

import pandas as pd
from sqlalchemy import create_engine

df = pd.read_parquet("data.parquet")
engine = create_engine("postgresql://user:pass@localhost/db")
df.to_sql("orders", engine, if_exists="replace", index=False)

SQLite via DuckDB COPY

duckdb -c "ATTACH 'app.sqlite' AS sqlite_db (TYPE sqlite);
           CREATE TABLE sqlite_db.orders AS
             SELECT * FROM 'data.parquet';"