api queries. complex queries. please explain

It’s not possible… yet (hopefully).

See this topic.