SQL 4 CDS allows you to use standard SQL syntax to query and manipulate your data in CDS / D365.


Where possible the queries are converted to FetchXML, allowing you to generate FetchXML queries for
plugins or integrations by writing familiar SQL and converting it.

Using the preview T-SQL endpoint, SELECT queries can also be run that aren't convertible to FetchXML.

Latest version release notes

Improved error reporting
Improved SQL compatibility
Added GETDATE and similar date functions
Added REPLACE function
Handle more SQL expressions in FetchXML
Improved FetchXML to SQL conversion


Version Release date Number of downloads Rating
2.3.0 8/28/2020 7:45:41 PM 2228 0.00
2.2.0 7/15/2020 7:41:00 PM 2646 0.00
2.1.2 5/27/2020 8:34:03 PM 3022 5.00
2.1.1 5/25/2020 8:47:12 AM 517 5.00
2.1.0 5/24/2020 10:05:44 AM 265 0.00
Show more versions (12 more)


Latest version

No feedback yet. Add yours

Other versions

(Marc Scheuner, )
Absolutely fantastic plugin for anyone who's at home in SQL, and misses the power and flexibility of SQL when working with Dynamics365 - wonderful job, Mark! Couldn't do my work without your plugin!

(Durgaprasad Katari, )
Great tool, can enable TDS endpoint easily without running the orgDBsettings exe.

(Nishant Rana, )
Awesome tool. Thanks !

(Patrick Lauziere, )
Great tool to extract data in fields order you want.

(Nicola Micheletto, )

(CRM Admin, )

(Rich Waring, )
Great to have a way to effectively run sql queries against the D365 back end - saved me a lot of time today.

Related information

Author: Mark Carrington Latest version: 2.3.0 Released on: 08/28/2020 Nuget package Id: MarkMpn.SQL4CDS Open Source: true Go to project web site Ratings (all versions) 5Average rating 7Number of ratings Downloads 2228Latest version 22625All versions 1330.88Average per version