Quotes are not added in text values ​​by default: SQL error: near "-": syntax error

[devmark404]

Environment:

• OS: Windows
• Godot version: 4.3
• godot-sqlite version: 4.4

Issue description:
I try to create a table with a default text

func create_table_tests() -> void:
	var table = {
		"id": {
			"data_type": "int", 
			"primary_key": true, 
			"auto_incremental": true, 
			"not_null": true
		},
		"date": {
			"data_type": "TEXT",
			"default": '2001-01-01 01:01:01'
		}
	}
	db.create_table("tests", table)
	
	pass

When creating it, the following error appears:
--> SQL error: near "-": syntax error

If I activate the verbosity mode
db.verbosity_level = SQLite.VerbosityLevel.VERBOSE

I see that the following query is being made:

CREATE TABLE IF NOT EXISTS tests (id INTEGER PRIMARY KEY NOT NULL,date TEXT DEFAULT 2001-01-01 01:01:01);

The error occurs because this date should have quotes:
date TEXT DEFAULT 2001-01-01 01:01:01

ok:
date TEXT DEFAULT '2001-01-01 01:01:01'

However, those quotes are not added when I add default text in the query

[2shady4u]

Hello @devmark404 😄

This can be solved by encapsulating the offending string in an additional pair of (double or single) quotes, see here: #42