A single dialect for all your data
CocoSQL is a unified SQL dialect based on DuckDB, that allows you to query data stored in multiple different systems, without re-writing anything.
Write your query. Coco handles the rest.
CocoSQL translates your query into your database's dialect, and takes into account things like function names, types, index offsets, NULLs, and more.
Full-Language Translation
CocoSQL adapts your query's structure, functions, and data types to the target database. The same query runs across supported sources without manual rewrites.
A built-in smart editor
Write CocoSQL with autocomplete and documentation built into the editor. Errors and warnings show you where to look, so you can refine your query without leaving your work.
Use SQL with visual changes. The best of both worlds
Write a query, then keep working visually. Coco lets you combine SQL with direct changes to your frame, so you can choose the approach that fits each part of your analysis.
