Things you can do with SPyQL CLI that you can't with clickhouse local (AFAIK, top of my mind, not exhaustive): - use python code in your queries - import pyth

Things you can do with SPyQL CLI that you can't with clickhouse local (AFAIK, top of my mind, not exhaustive): - use python code in your queries - import python libs (just install them with pip/conda) - write your one UDFs in Python - run OS commands from within the query (using os.system) - have guaranty of row order (like in grep, sed, etc) And there is more, please take a look at: https://spyql.readthedocs.io/en/latest/distinctive.html https://spyql.readthedocs.io/en/latest/distinctive.html