-
I’m not sure. I think API calls are limited by how your tables are named in the DB.
-
For joins and complex SQL operations, you will likely want to use stored procedures or views. You may also want to check out these forum threads:
- Yes! Check out our FAQs and this paper on scalability [PDF].