Create a View based on a SQL query in Drupal

Question

Is there a way to create a View in Drupal based on a custom SQL query? I made the query to test my results and everything is fine, but don't wanna go through the whole process of trying to recreate the same via the View UI...

I need to generate it as a View to use the exposed filters and be able to create different display modes, that's why I don't simply execute the command and display the results.

I found an old module called "Query-Based Views (Q-Views)" that would do the job, but it looks deprecated.

Thanks, Frank

Answer 1

One of ways: You can use Relationships. So write own query, add views support and attach to current views...