I'm not very technical so if this is a non-starter or there's a solid workaround that already exists, please advise.
We have users that query SQL data sources directly in other tools, but then would like to bring that query as a dataset to OAS. Ideally they could create the view in the database and reference that object from OAS, but most users have read-only access in the database.
The OAS logical SQL is of course not equivalent to database SQL; this means that the queries have to be re-constructed within the OAS logical SQL constraints. And often this is a material change, requiring a complete re-write of the code and the creation of multiple datasets to replicate what was done in the database.
It would be great if there was a way to bypass the OAS logical SQL processing and use the native database SQL instead, when necessary.
Thanks!
