[nonameiguess]

There actually is a Python API for doing this: https://pypi.org/project/dataframe-sql/

It doesn't expose a CLI, though.