The truly impressive feat (of Jira in particular, but also all of Atlassian's products in general) is how incredibly slow they are. I assume each page somehow touches every single row of every single table in the database because I don't know what else it could be doing to make page loads take so long.

It’s artificially slow to get you to upgrade. Wish I was joking. Thankfully my company uses Clubhouse/Shortcut which is orders of magnitude better.

That really couldn't be further from the truth, especially in Jira. Jira keeps virtually every piece of interesting information in a custom field, including built-in fields like issue titles and points (known as system fields but effectively the same thing). Every view you see is the product of a zillion complicated joins across field definitions, field schemes, field values, field permissions and other bits and pieces.

Why use a single query languange when one for each view is possible?

- Atlassian probably