Convert current TruncateOperator into a DropTableOperator

[dimberman]

The current TruncateOperator is implemented to drop tables instead of truncating them. This could cause critical issues with users who expect tables to exist after truncation. While not the correct action, there IS use for a DropTableOperator.

Acceptance criteria:

• Create an operator that given a table will drop said table.
• If the user does not have proper permissions to drop the table, give proper warning in the form of an error
• create a corresponding AQL function

Example:

@pytest.mark.integration
@pytest.mark.parametrize(
    "database_table_fixture",
    [
        {
            "database": Database.SQLITE,
            "file": File(DEFAULT_FILEPATH),
        },
        {
            "database": Database.POSTGRES,
            "file": File(DEFAULT_FILEPATH),
        },
        {
            "database": Database.BIGQUERY,
            "file": File(DEFAULT_FILEPATH),
        },
        {
            "database": Database.SNOWFLAKE,
            "file": File(DEFAULT_FILEPATH),
        },
    ],
    indirect=True,
    ids=["sqlite", "postgres", "bigquery", "snowflake"],
)
def test_truncate_with_table_metadata(database_table_fixture, sample_dag):
    """Test truncate operator for all databases."""
    database, test_table = database_table_fixture
    assert database.table_exists(test_table)

    with sample_dag:
        aql.drop_table(
            table=test_table,
        )
    test_utils.run_dag(sample_dag)

    assert not database.table_exists(test_table)