Support SQLConf for branch write similar to WAP

[jackye1995]

Feature Request / Improvement

As discussed in the community sync, support setting a SQLConf to write to a specific branch instead of the table's main branch.

Realted to #6651

Query engine

None

[jackye1995]

@rdblue I remember you said you would like to take this effort in the meeting?