It's designed for analytics work. Some examples:
* You could run a bunch of analytics queries directly on a jsonlines, csv, or parquet file (or even glob of files).
* You can output directly to a pandas or polars dataframe
* You can use numeric python functions inside of queries
* You can also attach to S3 buckets, postgres databases, or sqlite databases and query them directly.