BigQuery: Script -> CREATE (DDL) for stored procedure should show "IN" prefix for input parameters #1000
Description
What
When generating DDL for BigQuery stored procedure by right-clicking on the stored procedure and select Script -> CREATE (DDL), the generated DDL does not show the prefix "IN" for input parameters. It does show "OUT" for output parameters.
Why (problem/use case)
The BigQuery Console does show the "IN" prefix when generating DDL. Although BigQuery does not require the prefix "IN" for input parameters (the DDL executes just fine without it), it's best to follow the same convention used by the BigQuery Console. A lot of BigQuery SQL stored procedure DDLs out there were checked into Git with the "IN" prefix because they were previously scripted out from the BigQuery Console. Having DBCode outputting the "IN" prefix would avoid un-necessary diffs.
Additional Context
Add any other context, screenshots, or examples about the feature request here.