Search notes:

Office Object Model: Excel - QueryTable

Compare the queryTable object with the listObject and workbookQuery objects.

Connection

The .connection property is a string that contains the information needed to connect to a data source and query data from it.
This string consists of two parts that are separated by a semicolon.
The first part seems to correspond to the value of the queryTable's .commandType value (which is a value of the xlCmdType enumeration). Some values for the first part include
Such connections can be shown in the Ribbon under

TODO

The saveAsODC method allows to create .ocd (Office Data Connection) files.
Apparently, a queryTable's .recordSet property evaluates to a DAO record source (probably when the queryTable gets the data from an MS Access dtabase

Relationship with List Objects?

There is a 1:1 relationship between a queryTable and a listObject: the list object has the property .queryTable and the query table has the property .listObject which, at least in my tests point to one another.
However, not only list objects are consumers of query tables: for example, both the worksheet and range objects have a .queryTables property.

See also

Using a queryTable object together with list objects to query data from
A queryTable can use a workbookConnection object which (centrally) stores the information that is needed to access (external?) data.
Excel Object Model

Index