{"id":8976354,"name":"markmpn.sql4cds.engine","ecosystem":"nuget","description":"Convert SQL queries to FetchXml and execute them against Dataverse / D365","homepage":"https://markcarrington.dev/sql-4-cds/","licenses":null,"normalized_licenses":[],"repository_url":"","keywords_array":["SQL","CDS"],"namespace":null,"versions_count":64,"first_release_published_at":"2020-01-31T15:54:21.963Z","latest_release_published_at":"2026-05-21T07:37:51.550Z","latest_release_number":"10.4.0","last_synced_at":"2026-05-21T07:45:33.955Z","created_at":"2024-02-26T08:51:17.010Z","updated_at":"2026-05-21T07:45:38.885Z","registry_url":"https://www.nuget.org/packages/markmpn.sql4cds.engine/","install_command":"Install-Package markmpn.sql4cds.engine","documentation_url":null,"metadata":{"copyright":"Copyright © 2020 Mark Carrington","require_license_acceptance":false,"icon_url":"https://markcarrington.dev/sql4cds-icon/","readme":"docs\\README.md","language":"en-GB","development_dependency":false,"serviceable":false,"framework_assemblies":[],"package_types":[],"summary":"Convert SQL queries to FetchXml and execute them against Dataverse / D365","release_notes":"New features:\n* Load data from local files using `OPENROWSET(BULK)` function\n* Added `ABS`, `SIGN`, `CEILING`, `FLOOR`, and `ROUND` functions (thanks @sulimanbenhalim)\n* Added `defaultstatus`, `invariantname`, `state` and `transitiondata` columns to `metadata.optionsetvalue` table to show values from state and status code optionsets\n\nEnhancements:\n* Improved folding additional filters after extracting join criteria\n* Improved error handling for unnamed and missing columns in subqueries\n* Improved error handling for invalid constants while building query plan\n\nBug fixes:\n* Fixed missing values from `from` and `to` fields with aliased joins\n* Fixed JSON serialization of nested Entity/EntityCollection values in expando API responses\n* Fixed joins with additional filter criteria on virtual entities\n* Fixed aggregate query generation for `activitypointer` and elastic tables","dependency_summary":{"total_dependency_groups":2,"target_frameworks":[".NETFramework4.6.2","net8.0"],"total_dependencies":11}},"repo_metadata":{},"repo_metadata_updated_at":"2026-05-21T07:45:37.193Z","dependent_packages_count":0,"downloads":82928,"downloads_period":"total","dependent_repos_count":0,"rankings":{"downloads":12.965358840546001,"dependent_repos_count":13.819348826338206,"dependent_packages_count":18.835372714592,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":15.206693460492069},"purl":"pkg:nuget/markmpn.sql4cds.engine","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/nuget/markmpn.sql4cds.engine","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/nuget/markmpn.sql4cds.engine","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/nuget/markmpn.sql4cds.engine/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":null,"versions_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/markmpn.sql4cds.engine/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/markmpn.sql4cds.engine/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/markmpn.sql4cds.engine/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/markmpn.sql4cds.engine/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/markmpn.sql4cds.engine/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/markmpn.sql4cds.engine/codemeta","maintainers":[{"uuid":"MarkMpn","login":"MarkMpn","name":null,"email":null,"url":null,"packages_count":7,"html_url":"https://www.nuget.org/profiles/MarkMpn","role":null,"created_at":"2024-02-26T08:56:06.488Z","updated_at":"2024-02-26T08:56:06.488Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/maintainers/MarkMpn/packages"}]}