It's a limit in Postgrest. I've read some Postgrest discussions and it appears they want to keep selects simple thru the API and have you have to think about your SQL for more complicated stuff (RPC/Views). You could go lobby there, but my guess is it has come up before.