We transpile from Python to SQL using Calcite. Calcite works well as an engine t... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

jamesblonde on Feb 13, 2025 | parent | context | favorite | on: SQL pipe syntax available in public preview in Big...

We transpile from Python to SQL using Calcite. Calcite works well as an engine that knows enough SQL dialects to be practical.

leoh on Feb 13, 2025 [–]

+1 for Calcite. Any more details on what you’re doing? Are you using a python library on top of calcite? Something else?

jamesblonde on Feb 15, 2025 | [–]

We run Calcite in the backend. Python library sends DSL as json to the backend that returns SQL for the target engine.

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact