Trim semicolon in SQL queries?

[TobWen]

Would it be possible to RTRIM a trailing semicolon? It might introduce some trouble when:

$ echo '{ "type": "Point", "coordinates": [0, 0] }' | ogr2ogr -f GPKG test.gpkg /vsistdin/ -nln oldName
$ ogrinfo test.gpkg -sql "ALTER TABLE oldName RENAME TO newName;"
INFO: Open of `test.gpkg'
      using driver `GPKG' successful.

This creates a layer named newName; (including trailing semicolon) which might not be expected by the user.

[Even Rouault]

In 41139:

GPKG: trim trailing semicolon in ExecuteSQL() (fixes #7189)

[TobWen]

Might this not also affect other SQL based queries, like SQLite?