Bear in mind that using SQL in GnuCash may result in data loss:

> Note this feature is considered experimental. It works for most of the common use cases but some corner cases have been reported to result in data loss. [1]

[1] https://gnucash.org/features.phtml