BigQuery now supports theta JOINs, which use inequalities in key comparisons. But Google recommended that BigQuery users continue writing in legacy SQL until the beta moves to general release.