Make --detect-types the default behavior in 4.0

[simonw]

Here's another feature that we could change in 4.0:

sqlite-utils/sqlite_utils/cli.py

Lines 897 to 903 in fb93452

	click.option(
	"-d",
	"--detect-types",
	is_flag=True,
	envvar="SQLITE_UTILS_DETECT_TYPES",
	help="Detect types for columns in CSV/TSV data",
	),

It's already the default for the newer memory command, which instead has a --no-detect-types option:

sqlite-utils/sqlite_utils/cli.py

Lines 1858 to 1863 in fb93452

	@click.option(
	"-n",
	"--no-detect-types",
	is_flag=True,
	help="Treat all CSV/TSV columns as TEXT",
	)

[simonw]

Design decision: I'm going to have --detect-types continue to exist as an option just so anyone with an existing automation script won't get errors when they upgrade. I'll add --no-detect-types as the option to turn that off.