1) Essentially yes! You'll have to write SQL queries yourself 2) You'd want to have some way of sending events (simple api) to a Kafka cluster which would be read by Clickhouse, then you'd be able to query the data using metabase or datagrip.

(Or you can use PostHog, which has essentially done all this for you and has all the functionality that Mixpanel/Amplitude has, but you're able to self host it!)