Add pre-commit to prevent usage of session.query in Airflow Core

[ephraimbuddy]

Description

We should add a pre-commit that prevents the use of session.query in airflow core. We should limit it to the source and not the tests/ package for now. The core airflow was almost rid of session.query, but the usage is gradually increasing. Adding this would require fixing all the session.query usages in the core code

Use case/motivation

No response

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

[Prab-27]

@potiuk ,I'd like to work on this

[ephraimbuddy]

@potiuk ,I'd like to work on this

Assigned to you @Prab-27

[Anurag-Kumar-01]

i also want to take up this issue

[Prab-27]

Sorry ,Due to a hardware issue I have lost all my data

Could you please review a new PR: #47275 when you get some free time