fish doesn't use SQLite, but its own plaintext format. They've been trying to migrate to other formats.[1] Currently fish stores timestamps and directories in its history.

[1] https://github.com/fish-shell/fish-shell/issues/3341