There is not a problem in the database schema, AFIK. The table is really simple
CREATE TABLE IF NOT EXISTS "POWER" ( "ID" INTEGER PRIMARY KEY AUTOINCREMENT, "TIMESTAMP" DATETIME NOT NULL DEFAULT (datetime(CURRENT_TIMESTAMP,'localtime')), "TOTAL_KWH" NUMERIC);
I can get the data with the same SQL select query using the terminal and using the DB Browser For SQLite on the production machine.
Even partial SQL select (as I mentioned in my previous post) is working.
You can find the database file, DB Browser project file and sql query file
here