ReadFromBigQuery read with script (temporary functions)

AS a user I have a custom function that I use for querying a table. As such, I would like to build a Query on a beam pipeline with the function inlined there. However it seems that currently Beam readers do not accept this as I get:

```
{
"error": {
"code": 400,
"message": "configuration.query.destinationTable cannot be set for scripts",
"errors": [
{
"message": "configuration.query.destinationTable cannot be set for scripts",
"domain": "global",
"reason": "invalid"
}
],
"status": "INVALID_ARGUMENT"
}
}
```

Wondering if anyone has a recommendation on how to add support for this?

Imported from Jira [BEAM-10461](https://issues.apache.org/jira/browse/BEAM-10461). Original Jira may contain additional context.
Reported by: gcasassaez.