ctrl-d:execute(source ~/.zinit/plugins/larkery---zsh-histdb/sqlite-history.zsh && histdb --forget {}

error in -separator
select
id,
strftime(case when datetime(max_start, 'unixepoch') > datetime('now', 'start of day') then '%H:%M' else (case when datetime(max_start, 'unixepoch') > datetime('now', 'start of year') then '%d/%m' else '%d/%m/%Y' end) end, max_start, 'unixepoch', 'localtime') as time,
CASE exit_status WHEN 0 THEN '' ELSE '' END || replace(argv, '
', ' ') as cmd,
CASE exit_status WHEN 0 THEN '' ELSE '' END
from
(select
  history.id as id, commands.argv as argv, max(start_time) as max_start, exit_status
from
  history
  left join commands on history.command_id = commands.id
  left join places on history.place_id = places.id
where  places.host='localhost'
group by history.command_id, history.place_id
order by max_start desc)
order by max_start desc

latest up-to-date archlinux
fzf: 0.27.2 (8255aa2)
latest histdb
sqlite3: 3.36.0 2021-06-18 18:36:39 5c9a6c06871cb9fe42814af9c039eb6da5427a6ec28f187af7ebfb62eafaalt1