Even with an ODBC driver, TopSpeed is not a full RDBMS. You must understand the translation layer's capabilities.
MagnaCarta Software (now part of a broader Clarion tooling ecosystem) produced a robust ODBC driver. odbc driver for topspeed
(Not Recommended for Production)
Many driver vendors provide a button. If not, use Microsoft Query or a simple PowerShell script: Even with an ODBC driver, TopSpeed is not a full RDBMS