Importing plain text/CSV files

[abhi-deshpande]

Is your feature request related to a problem? Please describe. Currently, importing a database as an SQL script is possible, but it is not possible as a CSV or text file. An SQL script is not very lightweight and large scripts may cause the program go unresponsive. Importing CSV or TXT via LOAD DATA LOCAL INLINE is very inconvenient, in case a table has lots of columns.

Describe the solution you'd like An import feature that allows to -

• Select a plain text file from storage.
• Select a table in which it is desired to be imported.
• Select the desired delimiter/allows to enter one.
• Select whether the CSV has a header.
• Automatically create the columns, or allow to optionally drop ones which are already present and re-create.

Describe alternatives you've considered I really loved the simplicity of Antares, but for importing CSV, I am currently using DBeaver or Dbgate. They have direct import options for plaintext.

Additional context I know this may need really a lot of work, but it would be a good to have feature.