GeezerVison

The Import CSV dialog always created the table in the main schema and
looked for an existing table of that name there. Add a Schema selection
next to the table name so a file can be imported into the temp schema or
into an attached database. It defaults to main, so nothing changes unless
the user picks another schema.

The temp schema is always offered because SQLite does not report it
until something has been created in it.

The INSERT statement used the unqualified table name, so rows went to
a temp table of the same name instead of the table which had just been
created in main. Use the schema qualified name for it.

Close: sqlitebrowser#2443

When importing a CSV file into an existing table, the columns of the
file were inserted in the order they are in, whatever their names were.
A file with the columns in a different order than the table, or with
additional columns, could not be imported without editing it first.

Add the advanced option "Match columns by name". When it is on and the
first line contains the column names, each column of the file is
imported into the table column with the same name (ignoring the case).
Columns of the file which have no match are skipped and columns of the
table which are not in the file get their default value. The option is
off by default, so the import works as before unless it is turned on.
It only has an effect on tables which exist already.

Refs: sqlitebrowser#243

Numbers in the data browser were always shown the way SQLite writes
them, e.g. 1234567.5, whatever the number format of the user is.

Add the option "Show numbers in the system number format" to the data
browser preferences. When it is on, the values of columns with an
INTEGER, REAL or NUMERIC type affinity are shown with the digit grouping
and the decimal separator of the system locale, e.g. 1.234.567,5. It is
off by default, so nothing changes unless the user turns it on.

Only the display changes. The digits are never rounded, and what is
edited, copied or exported stays the plain number. Values which are not
plain decimal numbers, such as text or numbers with an exponent, and
columns with a display format are left as they are. Columns without a
numeric type and the results of SQL queries are not changed either
because there is nothing which tells a number from a text in them.

Refs: sqlitebrowser#3718