New version of Microsoft SQL Server integration, planned deprecation of Version 1 and Version 2
Retool released a Version 3.0 of the Microsoft SQL Server integration that includes various fixes and improvements. New Microsoft SQL resources will use this version by default. Existing resources can be updated using the Connector version setting.
Beginning in the 2026 Q3 stable release, Version 1.0 and Version 2.0 of the integration will be deprecated. Retool strongly recommends that you update your resource configuration before Q3 in order to prevent any interruptions and to resolve any unforeseen issues. If necessary, Retool may automatically migrate resources to Version 3.0 in order to ensure any issues are identified and resolved prior to the removal of the old versions.
There is a known breaking change introduced in Version 2.0 that will also apply when upgrading from Version 1.0 to Version 3.0:
Beginning in Version 2.0, array inputs must be passed as a string when used in string_split in order to pass the Microsoft SQL SDK validation. For example, select * from string_split({{[1,2,3]}}, ','); must change to select * from string_split({{[1,2,3].join(',')}}, ',');.
No breaking changes are expected between Version 2.0 and Version 3.0.