PickedQL

PickedQL is a SQL query language for your Picked analytics data. Write short SQL with a virtual table and a virtual function. PickedQL expands them into a full query, and it adds the joins and the A/B test aggregations for you.

Related

• About PickedQL — what the layer expands, and why a tenant filter is required.
• Analytics queries — worked examples.
• Data sources — every table.
• Filters — the filter string a virtual function takes.