Feature: add optional managed connection (#52700)

https://github.com/apache/airflow/commit/bc35370c49251b2349191db3d8f061b3f714aa3d