Tableau is a read only software. I dont believe it will perform the actions are looking for above.
May be providing further details can help the community address issue better.
What is the database that you are connecting to? If it's Teradata, you can create session specific volatile tables through Initial SQL statements. For MS SQL, you may want to refer this: https://community.tableau.com/thread/136238