query = """
        INSERT INTO vklad_trans
        SELECT * FROM trans
        WHERE operation = 'VKLAD'
        """
pd.read_sql_query(query,engine)

# with this query we are inserting into the table/schema vklad_trans