I want to access an ODB file (made with LibreOffice Base) in Python and extract a table for further use. The ODB contains several tables, one relation design and several forms.
Is it possible to achieve this without using any SQL?
Edit: Since it seems overcomplicated to parse this format on my own, i'll consider using a proper HSQLDB engine.
What python module accesses via HSQL (like sqlite3 for SQLite does)?
You can consider Python Uno API that comes with OpenOffice. There are several Python examples to interact with the API, including one with the sample database
There is also this SO question where it is explained how to use uno with LibreOffice.