The extract file generated by TDM isn't incorrect. The query not recognize the command "TOP 100".
The query in extract file needs to contain all the clauses for use during extract process.
Test Data Manager
TDM
Subset
We do not support TOP keyword. We only support subsetting based on where condition.
However, you can specify a value for number of rows.