Hi, you’re able to create a stored procedure and call that to perform joins on a mysql db… You simply create the procedure and then call it using a GET via the live api.
If you want to study up on this, familiarize yourself with how exactly the users/roles system works. Because this has an important impact on knowing what you’re giving your users access to when simply doing a GET on a stored proc. Effectively, data can be manipulated through the stored proc without even giving the user delete/update access to that rest verb.
Thanks,
Mark