add MATERIALIZED keyword to ring-fence some CTEs (i.e. WITH blocks)

[DLN] add MATERIALIZED keyword to some CTEs (WITH blocks) to ring-fencing behavior of postgres 10 for those CTEs. Disable jit compiling of queries for entire hivemind datbase because it mostly hurts performance of hivemind queries which typically don't have long execution times but are complex queries that take a long time to compile