Hello,
first of all, what I want to do is to expose data from a external SQL Server as a REST API to be consumed by a Ruby on Rails webapp.
I have been trying Dreamfactory and so far I understand how to expose endpoints from single tables and how to filter them and stuff, but I would want to know if I can expose an endpoint based on the result of a custom SQL Query, writing it in just SQL.
On the other hand, is possible to filter the results of this custom SQL query depending on the http params sent by the client?