Method: Generates a virtual table given a list of IDs.

Method: Returns a comma separated list of the fields in the `query_args`, if there aren’t, returns `report_columns` keys.

Method: Returns a comma separated list of the field names prepared to be used for a selection after a join with `default_results`.

Method: Fills ORDER BY clause of SQL request based on user supplied parameters.

Method: Fills FROM and WHERE clauses of SQL request for ‘Intervals’ section of data response based on user supplied parameters.

Method: Get join and where clauses for refunds based on user supplied parameters.

Method: Maps order status provided by the user to the one used in the database.

Method: Normalizes order_by clause to match to SQL query.

Method: Fills in interval gaps from DB with 0-filled objects.

Method: Converts input datetime parameters to local timezone. If there are no inputs from the user in query_args, uses default from $defaults.