Design for Write Database

[wdanilo]

This task is automatically imported from the old Task Issue Board and it was originally created by James Dunkerley.
Original issue is here.

---

Similar to Table.write for in-memory.

• Create a new table
  • Specified table name
  • Overwrite with warning or error
• Append data
  • Map columns by Name or Position
• Update data
  • Using primary key to join on
  • Option to remove unmatched rows
• Delete data
  • Using primary key to join on

Additionally transaction support.

[jdunkerley]

Tasks to complete:

• Add create_database_table to In-Memory table. #6326
• Add create_database_table to Database Table #6327
• Include indices of duplicate rows in the Non_Unique_Primary_Key error #6437
• Add update_database_table to In-Memory table #6498
• Add execution context control to the Database write operations. #6887
• Implement remaining Update_Actions for update_database_table. #7035
• Add Table.delete_rows function allowing deleting rows in a database table. #7238