I have to play games of using multiple SQL requests to avoid JOINS that are very slow and this is just inefficient and frustrating. If this was just a reasonable limitation, then I can accept it. But even back to VFP's Rushmore SQL engine from a decade or two ago is faster than what we get in FileMaker now. I know FM's target audience is not high end transactional database users, but for individual processes, I would hope we could have similar speeds or at least 75% of the high end SQL databases.

An example of what I sometimes have to do for reasonable performance and avoiding JOINS are: