When creating a new database via Menu | File | New | Database ==> (*)Connect to an existing Database [Text], (basically, to link to an entire folder full of CSV data files), will the default underlying embedded database be an HSQLDB, Firebird, or neither? If it’s neither, what would it possibly be?
In connecting to a text file or spreadsheet and such, there is no underlying database. It is simply a link to the existing data.
This may also be of interest to you → [Base] Linked Table from CSV. See link in accepted answer.
I see. That’s probably why the resulting tables not relational, and therefore cannot queried via SQL statements. Correct?
You can do very simple single table SQL such as:
Select * from TABLE Where ID = '1'