This module allows you to use SQL expressions within Drupal Views for fields, filters, sorts, and arguments. It leverages Twig templating for more powerful and flexible custom queries, enabling complex computations and direct SQL input.
This module uses twig to support SQL expressions for fields, filters, sorts and arguments. Users can also enter SQL expressions directly. Twig support allow more powerful computation to be performed. It can also be used to provide raw SQL expressions.
SQL Support
This project supports SQL customized:
- Fields
- Filters
- Sorts
- Arguments
- Relationships (using an optional module)
Notes
Use of Twig and SQL provides more flexibility but it requires an understanding of both to be used effectively. It is relatively easy to implement simple extensions such as aggregating/summing a Twig SQL field that compares another field to some value such as a cost greater than 100. Some checks are provided to limit any problems and assist in debugging but it is good practice to keep backups of a view before and after adding SQL changes. You have been warned.