databow: a Rust CLI to query any database with an ADBC driver

ADBC: https://arrow.apache.org/docs/format/ADBC.html

Seems like a columnar version of ODBC, for OLAP instead of OLTP.

Golang: https://github.com/xo/usql

Reviewing the issues and PRs there provides a clue what to expect as this project matures.

Sorry, just trying to understand. Why would I use this over duckdb. duckdb already has plugins for a lot of databases. Is the syntax the advantage?

My biggest pain point with using different cli to connect to different databases is that they all do things like listing tables differently.

Another nice feature one would want from such a program is of course auto complete.

This is excellent! I'm not a data engineer or SRE or whatever other commenters have mentioned. But part of my job is accessing data in various formats from various places, mostly offline. This in gonna be part of my toolset and I can pipe the output into other tools like nushell too.

Cool! But as a data engineer I don't know when I would ever use this. Getting data into a centralized place so it can be joined and queried easily is like prio 1 for any data team.

I'm sure SREs will really love me doing expensive adhoc queries against production postgres /s

I've yet to work in enterprises big enough to have multi cloud data warehouses though, maybe it's more useful in that setting?

this is my first comment