Api4SelectQuery

Why walk when you can

Joins onto an fk field

Adds one or more joins to the query to make this field available for use in a clause.

Enforces permissions at the api level and by appending the acl clause for that entity to the join.

Get join info for dynamically-joined fields (e.g. "entity_id", "option_group")

Joins onto a custom field

Adds a join to the query to make this field available for use in a clause.

Fetch a field from the getFields list

Perform input validation on params that use the join syntax

Arguably this should be done at the api wrapper level, but doing it here provides a bit more consistency in that api permissions to perform the join are checked first.

Check permission to join onto another api entity

Get acl clause for an entity

Populate $this->selectFields

Gets all FK fields and does the required joins

Recursively validate and transform a branch or leaf clause array to SQL.

Validate and transform a leaf clause array to SQL.

Get table name on basis of entity

Separates a string like 'emails.location_type.label' into an array, where each value in the array tells whether it is 1-1 or 1-n join type