how well does the flatten() translation work in practice? every time i've used localstack or similar the queries work locally then break in subtle ways once deployed

Nice! I'll give it a try!