The current accepted Object-Query-Language (OQL) in AIP Studio is lacking in some expected capabilities.
For example, a query can only reference a single object. Then you can use the result to query a related object. This often then requires multiple steps of interaction with the LLM for a single activity. Its not impossible, its just slow. And this degrades the user experience.
One cannot use SELECT, ORDER BY, or LIMIT statements, which the LLM keeps trying to do (unless you include additional prompt instructions to warn the LLM).
I am constantly correcting the OQL errors with improved prompting instructions. This takes away time and focus from the core aspects of my work.
Overall, my sense is that OQL is still in an early version and needs to be upgraded to get to the level expected (by the LLMs at least).