Formula.Firewall workarounds?

How do you write dynamic code to fetch and merge data in M without this "feature" rearing it's ugly head? I don't want to split up my code in 23 different queries and I'm going to host the app online so ignoring privacy levels is not an option.