intermediate layer able to create and query temp tables