SQL Action Matrix

Action Matrix (Request For Comments)

Class: Persistence_SQL
Method: action()

https://github.com/atk4/data/blob/develop/src/Persistence_SQL.php#L167

This method constructs DSQL Query for requested action. It is doing it differently depending on 'type'. Here is how it currently works:

• insert: init, mode
• update: init, mode, conditions, limit, order, hook
• delete: init, mode, conditions
• select: init, fields, conditions, limit, order, hook
• count: init, field, conditions, hook,
• field: init, field, conditions
• fx: init, field, conditions

hook = initSelectQuery (there are other hooks that can be executed outside of action())

Please provide your feedback and recommendations on which parameters should be applied on a query or if you think more action types are required.