Description

A sql sensor which uses Standard SQL due to default one uses legacy sql

Use case / motivation

Currently (correct me if I am wrong!), the sql sensor only supports legacy sql. If I want to poke a BQ table, I do not think I can do that using standard sql right now.

Are you willing to submit a PR?

If community approves of this idea, sure!