Views SQL Twig Fields

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.