Add BigQuery as supported library for implemented functions

Add BigQuery as a supported library for functions that have already been implemented for other libraries. This ticket overrides CALCITE-5384 to include other functions that need BQ added as a supported library.

List of functions:

• MD5()
• SHA1()
• GREATEST()
• LEAST()
• COSH()
• SINH()
• TANH()
• FROM_BASE64()
• LEFT()
• LTRIM()
• REPEAT()
• REVERSE()
• RIGHT()
• RTRIM()
• SOUNDEX()
• TRANSLATE()