is there a way to have hugsql use two different adapters for different sql statements

I have a "query all the things" usecase that seems like would be alot easier if i could wire up hugsql defined queries to two sql datasources separately

(well, more specificially it feels like all it would take would be a custom adapter to make hugsql work perfectly with cassandra's CQL)

Yes, you can pass in the :adapter in the options map during the db function call. See the last example in this section of the docs: https://www.hugsql.org/#adapter-other

I think I recall somebody mentioning a lib that mixed hugsql and c*

https://github.com/troy-west/arche/tree/master/arche-hugcql

Here you go

i played around with arche/hugsql awhile ago and found it pretty easy to get up and going

well i feel alot less original, but im glad its been done successfully