Will we be able to design join queries with the help of codeless if we take Professional Services?
Hello,
View should solve your issue, when you create it, then find data in the View as in any other table, using codeless or any other sdk.
Or you do not like View in some reason?
@sergey.kuk Ya previously it was suggested to create View and it works fine, But is it possible to do it without creating views?
Short answer is no. But the feature is in our roadmap, we have not implement native relation support for external database yet. This task has low priority, because there is work around with View and not many developers ask about it
As a part of the professional services engagement we would be able to add an API which lets you run any SQL statement against your external database. Would something like this work for you?