Hi, does anyone know of ways to dynamically construct SQL queries for Pinot? Our data is spread across multiple tables, and we're looking for an efficient way to query it. Thanks!

adding a layer on top of it like php 😇 I've done it to buid dynamic query based on customers settings !

Hey @Indira Vashisth, how about offloading it to a temporary storage where you can perform joins? For example, offload the subset of data from the tables you need and perform joins?