[Databricks provider] Add `deferrable` support to `DatabricksSqlOperator`

[tatiana]

Description

Allow the DatabricksSqlOperator to be run using deferrable mode.

Use case/motivation

I want to execute SQL code in a Databricks SQL endpoint or cluster using the DatabricksSqlOperator in deferrable mode.

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[pankajkoti]

Adding deferrable mode to the DatabricksSqlOperator does not look straightforward as we do not get a poll-able query ID against the submitted SQL using the databricks connector that's getting used as part of the current operator implementation. However, it appears that Databricks does support to submit a SQL dynamically using the Statements Execution endpoint feature and then poll for the statement ID as part of its GET endpoint. I am working on adding a new operator to leverage this feature in PR #48507