I normally use DB4S to create my databases, and when you create a new table, DB4S uses grave accents around each identifier.

This is also reflected in the schema column.
However, as soon as you modify the table, the schema column changes to double quotes around the table name.

However, the 'create table' window at the bottom of the 'Modify Table' dialog still uses grave accents.

I remember reading recently about double quotes and apostrophes (single quotes), but can't find it now. But I did see this about quoting, and it said using grave accents was purely for MySQL backwards compatibility.
https://www.sqlite.org/lang_keywords.html

It suggested using double quotes for identifiers. I note the examples on the sqlite website doesn't use any quotes at all, apart from when to escape an apostrophe:
INSERT INTO xyz VALUES('5 O''clock');
Again, suggesting strings should be enclosed in single quotes rather than grave accents.

Should a standard be adopted, rather than a mix of bits?