u/Altruistic_Load_4369

im building a bi tool that supports multiple sql databases and we are hitting lots of edge cases because of regex based sql generation and rewriting how do mature bi platforms solve this do they use ast sql parser dialect compiler or something else looking for advice from people who have built similar systems