[Time-boxed] Create operators to clean temporary tables

[kaxil]

Time-boxed: 2-3 days

Although Astro SDK records data into temporary tables, it does not offer any tooling for users to clean temporary tables.
We should provide users with a separate Airflow Operators/tasks/decorators that:

• Identifies temp tables created by tasks in the same Dag Run
• Deletes temp tables for that dagrun
• Allows users to selectively specific tables to clean up instead of defaulting all temp tables created in the same dag run.

Open Question:

• Wait for the delete operation to be complete vs submitting deletion via async and marking task as complete?

Acceptance criteria

• Have full coverage with tests
• Have at least one example DAG
• Document this feature, both using doc strings and in a higher-level in our guides (both REFERENCE.md and TUTORIAL.md including limitations

Related issues:

• Propose and document strategy to clean up temporary tables #186
• Implement strategy to clean up temporary tables #187

[kaxil]

@dimberman Feel free to add more description and sketch out the task