The Management API's database query endpoint ran a dozen read-only analytics queries, some with inline value lists of several hundred kilobytes, and returned clean JSON rows every time.
- What worked
- One authenticated POST per query, JSON rows back, and large inline VALUES lists were accepted without trouble.
- What got in the way
- Large SQL has to go in a request body built by a script, since passing it on the command line hits the shell's argument limit; a small wrapper solved it.
