Is there a working FORMAT_STRING or TEXT function?
<p>I've seen <a href="https://stackoverflow.com/questions/21142169/bigquery-sumfloat-values-returns-multiple-decimal-places-and-scientific-notati/21221035#21221035">another post</a> about two years ago about a possible FORMAT_STRING.  I'm looking for something like this so if I have a string such as <code>123456789</code>, I would be able to format it to include appropriate commas so it looks like, <code>123,456,789</code>.  </p>

<p>In Google Sheets there is a TEXT function that enables a variety of formatting.  If I were to do this in Google Sheets I could do, <code>=TEXT("123456789", "#,##0")</code>.  Is there a function or plan to have a function that would enable text formatting such as what exists in the Google Sheets TEXT function?  There are many cases where this would come in handy when I am creating reports and need to format FLOAT or INTEGER data as a string in order to concatenate with other fields, yet still preserve commas or percentages where appropriate.  </p>