Have you already checked the scenario in component reference about:TalendHelpCenter:tBigQueryInput?
What does your Standard SQL look like?
What we can do is to make sure that Talend will be your best choice!
Of course I did, it is not supported.
A new feature needs to be added cause some of the possibilities are only for Standard SQL vs. the Legacy SQL which Talend supports.
there is an easy way to do it () however Talend doesn't support it.