Dumb question

I am planning an application using TMS Webcore and would like to access my database directly like I work with Firedac in a client/server environment.


I would like NOT to use aurelius as the queried data is often complex queries that require some SQL acrobatics and I am a heavy SQL user who wants to have total control also over execution plans.

Is this possible with remote DB?

Thanks
Michael

RemoteDB is not safe to use from TMS Web Core, just because of the architecture of final application. You SQL statements will be visible from the browser and also any user with credentials could execute arbitrary SQL statements.

You should use XData. You don't need to use Aurelius, XData is a generic Rest/Json framework, Aurelius is just a helper - which you can still use to retrieve simple data. But you can simply use SQL statements: 
https://www.youtube.com/watch?v=2SCvzw0L27o

Thanks, I will go with XData ...