Here’s some good info for configuring ODBC for MariaDB on Ubuntu for use from LibreOffice Base: LibreOffice Base and MariaDB. The same article also has some info about how to use ENGINE=CONNECT for importing JSON from web services.