I have used libre office base and found it's buggy mess.

1. Not all drivers support all functions, so if you are wondering why some options are not present it's probably adapter not supporting it.
2. Errors and help are usually empty or super generic like 'syntax incorrect'.
3. Interface sometimes bugs out when long syntax is present in input fields
4. Because of 1. It also doesn't support all syntax from Microsoft SQL, MySQL etc.

I sugest to use dbbever for any DB, it's different but at least it's not a buggy mess. Or pgAdmin for Postgresql. Or DB Browser for SQLite