The SQL
SELECT * FROM [dbo].[lime_tokens_841351] [lime_tokens_841351] WHERE [dbo].[lime_tokens_841351].[tid]=1

I added in
/limesurvey/vendor/yiisoft/yii/framework/db/schema/CDbCommandBuilder.php

in function
public function createColumnCriteria($table,$columns,$condition='',$params=array(),$prefix=null)

after

if($prefix===null)
$prefix=$table->rawName.'.';

the line
$prefix = '';

to remove the "[dbo]." from the [dbo].[lime_tokens_841351].[tid]=1

so the WHERE clause fit the alias Name.

I'm sure that this "fix" is not valid for all situation and should be somewhere in the limesurvey part, but it would be good if this issue cloud be fixed for all user, who also use Microsoft SQL Server.

Probably in limesurvey/application/models/LSActiveRecord.php

Yes, it is better to change line 206 in application/models/LSActiveRecord.php to damange not other parts of the application.
I changed
$criteria = $builder->createColumnCriteria($table, $attributes, $condition, $params);
to
$criteria = $builder->createColumnCriteria($table, $attributes, $condition, $params,"");