LibreOffice Base requires the ODBC SQLite3 driver to be installed, but luckily it is in the repositories on Fedora.
This post is so far only helpful in some of the setup for using Base with SQLite. None of the usual options for creating primary keys are showing for the SQLite databases. Yet tables can be saved to the databases. Not sure if this is a problem with the specific driver, or a user malfunction, etc.
Why ODBC?
(Open Data-b-ase Connectivity)
SQLite3 developers might have programmed compliance specifically for the aging MS Access and/or LibreOffice Base applications. However, they chose general compliance with ODBC.
ODBC is a recognized, industry standard catch-all for compatibility between many relational databases. There is no such thing as a native ODBC relational database, as it is a connectivity API.
LibreOffice Base has compatibility with ODBC, as long as the system has the right ODBC drivers.