Another question on my discovery path, has anyone tried to use peewee to query questdb using the postgresql protocol?

have not seen much usage of this tool, generally ORMs are a tricky proposition because they will require some functionality that our PGwire does not support yet

Using an ORM with QuestDB is like attaching a stagecoach to an SUV.

I see, so would you advise going to psycopg2 directly?

Yes just query directly using psycopg2 and grab the data you need as a stream.