sqlite> CREATE TABLE 'Open|SpeedShop' (version INTEGER);
sqlite> INSERT INTO 'Open|SpeedShop' (version) VALUES (1);
One of your problems is that you are using single quotes for a delimited identifier, "Open|SpeedShop", when you should be using double quotes.
Single quotes means a string literal in the SQL standard, where double quotes a delimited identifier, which are very different things.
On the other hand, I think the SQL standard lets you define your own delimiter, for delimited identifiers, but even in that case it seems wrong to pick the same kind as that which always means string literal.
-- Darren Duncan
