Join multiple Calc sheets in a Query

In MS Excel, using ODBC, I can join multiple Sheets of an .xlsx in a single Query, using ODBC SQL syntax - to create a new Sheet with the combined values. There is no pasting involved, so that - when the underlying Sheets are updated - the new, combined Sheet reflects that change.

Is this possible in LO ?

If not, can I view and edit a native LO database table using Calc? That is, view, edit, and format the table data as if it were a Calc Sheet? But with the data maintained in the LO database table - no pasting involved.

No, it is not possible in a simple way. Suggestions you can give up on Bugzilla. Thank you for everything!