4 ms·

Don't know about CH, but with apache druid, you can "join" with a rdbms query via a LOOKUP sql function.