gourmand generates SQL that is invalid for postgresql gourmand crashed with (Background on this error at in do_execute(): https://sqlalche.me/e/14/f405)

[Steve Langasek]

Running gourmand with a --database-url pointing to my postgres database fails immediately with the following backtrace. It is generating SQL that may be valid for sqlite but is not valid for postgresql.

ProblemType: Crash
DistroRelease: Ubuntu 24.04
Package: gourmand 1.1.0+really1.1.0~rc3-3
ProcVersionSignature: Ubuntu 6.8.0-31.31-generic 6.8.1
Uname: Linux 6.8.0-31-generic x86_64
NonfreeKernelModules: zfs
ApportVersion: 2.28.1-0ubuntu3
Architecture: amd64
CasperMD5CheckResult: unknown
CurrentDesktop: ubuntu:GNOME
Date: Fri May 24 08:48:52 2024
ExecutablePath: /usr/bin/gourmand
InstallationDate: Installed on 2019-12-23 (1614 days ago)
InstallationMedia: Ubuntu 19.10 "Eoan Ermine" - Release amd64 (20191017)
InterpreterPath: /usr/bin/python3.12
JournalErrors: May 24 08:48:55 hostname NetworkManager[2893]: <warn> [1716565735.9215] device (veth01294ac0): Activation: failed for connection 'Auto Ethernet'
PackageArchitecture: all
ProcCmdline: /usr/bin/python3 /usr/bin/gourmand --database-url=postgresql://borges/recipes
Python3Details: /usr/bin/python3.12, Python 3.12.3, python3-minimal, 3.12.3-0ubuntu1
PythonArgs: ['/usr/bin/gourmand', '--database-url=postgresql://borges/recipes']
PythonDetails: N/A
SourcePackage: gourmand
Title: gourmand crashed with (Background on this error at in do_execute(): https://sqlalche.me/e/14/f405)
UpgradeStatus: Upgraded to noble on 2024-05-22 (2 days ago)
UserGroups: adm cdrom dip libvirt lpadmin lxd plugdev sambashare sbuild src sudo
modified.conffile..etc.apport.crashdb.conf: [modified]
mtime.conffile..etc.apport.crashdb.conf: 2024-05-23T16:12:43.275502