• 79bf414 Handle virtual entity providers that don't respect filters
• 06de393 Merge pull request #507 from MarkMpn/virtualentity
• b02a56d Merge branch 'master' into virtualentity
• e56960e Removed System.Text.Json dependency
• 1a86ada Updated release notes and dependencies
• 5ce82df Merge branch 'virtualentity' of https://github.com/MarkMpn/Sql4Cds into virtualentity
• 4c6d313 Fixed generating error on invalid lookup/optionset comparison to string [ #506 ]
• 09bccb4 Merge pull request #505 from MarkMpn/virtualentity
• f7edef3 Merge branch 'master' into virtualentity
• f7668c0 Merge pull request #504 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.XTB/Azure.Identity-1.11.4
• d5cf5bd Use in-memory implementations for DISTINCT, OFFSET/FETCH, ORDER BY and TOP when working with virtual entity providers [ #503 ]
• 2b1a8a1 Bump Azure.Identity from 1.10.3 to 1.11.4 in /MarkMpn.Sql4Cds.XTB
• 15b2c89 Merge remote-tracking branch 'origin/master' into virtualentity
• 5354131 Merge pull request #502 from MarkMpn/copilot
• cc9bc71 Handle virtual entity providers returning values of different types than described by the metadata [ #152 ]
• 9a1bdd8 Simplified using OpenAI
• 71dd652 Improved copilot error handling
• 9fd57a2 Fixed use of OpenAI vs Azure OpenAI
• 9e74589 Keep focus in copilot
• 9868b63 Fixed showing/hiding copilot
• 972630c Settings form update
• 139359b Settings form update
• f1d5519 Delay-load message details
• fc041ab Added options to set up assistant for copilot
• 13d2e8c Hide the copilot panel if it is not configured
• b1d6087 Merged from master
• 6bcea62 Merge pull request #499 from MarkMpn/v9-fixes
• 6ae0116 Updated version number variable
• 14d5936 Updated CI build versioning to match release build
• 5a673d8 Include new dependencies in nuget package
• e58e826 Updated multitargeting
• 34d81ae Updated post-build events
• 97ee289 Updated gitversion task versions
• f138613 Use new gitversion task
• 5341e33 Updated build process
• 5acb9e0 Added using
• 8d93ccf Merge remote-tracking branch 'origin/master' into v9-fixes
• b7df402 Do not use attributes from semi-joins for custom paging. Fixes #498
• 69f2e02 Updated namespace
• 428f8e1 Added export handlers to ADS extension
• d2b663f Made entity references clickable links in Excel exports
• 50ade3c Refactored multi-targeting
• b029f12 Added initial export to CSV/Excel for XTB tool
• a57cf81 Improved error reporting when using wildcard instead of column name
• 680bb82 Improved error reporting for invalid operator types
• e0dd417 Improved error reporting on aggregate parameter counts
• 6008bb4 Fixed build error
• 8f8714d Improved error reporting when using SELECT * in scalar subquery
• b666450 Improved reporting of error when using SELECT * in scalar subquery
• 4328472 Fixed exposing collation of CAST/CONVERT to string
• 9ff0f41 Fixed incorrect type conversion errors when using specialized FetchXML comparison conditions
• 55ea349 Allow changing editor font and size [ #444 ]
• e1de76e Added keyboard shortcuts to switch and close tabs [ #457 ]
• a4bd989 Merge pull request #497 from MarkMpn/v9-fixes
• 1844287 Avoid folding aggregates on audit entity using inner joins [ #488 ]
• e1c416c Added more special cases for filtering specific attributes on audit entity
• 7067563 Clone metadata query to simplify logic of applying filters
• 845f623 Replace parameter values in metadata filters on each execution [ #495, #496 ]
• 9d81921 Fixed tests
• 539083d Updated tests with new not-null filters
• 868edb7 Merge remote-tracking branch 'origin/master' into v9-fixes
• d260783 Updated not-null test to use a nullable column - filter now gets removed otherwise
• 9ec8644 Identify tautological and contradictory filters
• 2b49000 Defined columns in outer joins are nullable
• 9a98441 Add not-null filters for hash join keys [ #491 ]
• bf94c01 Merge pull request #493 from fowl2/createdOnNull
• 1d39bf8 Fixed failing tests
• 0567793 Merge branch 'master' into createdOnNull
• bba57b5 Merge pull request #490 from MarkMpn/v9-fixes
• c8dde05 Merge branch 'v9-fixes' of https://github.com/MarkMpn/Sql4Cds into v9-fixes
• 8f11401 Updated tests
• a6db135 Copilot progress
• b434ab9 fix "Column 'createdon' does not allow DBNull.Value" [ #492 ]
• 843a670 Merged from v9-fixes
• 5424f8e Merge branch 'master' into v9-fixes
• d96542b Fixed cross-entity column comparisons using <> and IS NOT DISTINCT FROM [ #486 ]
• 43896c7 Initial copilot work
• 5c3f108 Added scripting of stored procedure execution
• 9bb1b0a Extract SQL error number from exception text
• da7a985 Added context menus for creating scripts to work with tables
• 00848b8 Use simplified metadata structure for autocomplete
• 566c9f1 Refactored getting list of available virtual attributes
• 3a71157 Fixed execution count for RAISERROR/THROW
• 426c682 Avoid using cross-table column comparisons on earlier versions (on-prem) [ #486 ]

This list of changes was auto generated.

• 0ddf1b7 Updated release notes
• 1d3558e Merge branch 'v9-fixes' of https://github.com/MarkMpn/Sql4Cds into v9-fixes
• d00a066 Use column ordering setting to also order TVF/sproc parameters [ #473 ]
• 869bb0e Added support for partitionid column in elastic lookup values [ #482 ]
• baf51f0 Added support for partitionid field as part of elastic lookup columns
• 532c569 Updated MaxLength handling
• 5ca3c92 Added recycle bin access via bin schema [ #471 ]
• b240cbd Avoid useraworderby to fix paging issues
• 18199f9 Improved primary key calculation
• 63594b1 Updated test to expect more efficient sort folding around index spool
• 48970b0 Added test for #479
• 1b87eed Allow visualising more types
• bcdf02a Added property grid
• 58e6b0a Use updated debug visualiser system
• 13a5e3a Use spools for subqueries in join conditions
• 9d91698 Updated test
• 7702e46 Added not-null filter to index spool key fields
• bcfdaf0 Added debugger visualiser for execution plans
• 56dbf9f Join condition subquery progress
• ba73e5f Fold subqueries in join conditions to appropriate side of join
• 62cc0a0 Do not attempt to apply aliases to virtual columns [ #477 ]
• 2fcfa61 Subquery in join condition progress [ #476 ]
• 68cb0d6 Fixed error with joins in [NOT] EXISTS subqueries
• bce25cd Updated test for custom paging fix
• ddb282f No need to do custom paging for TOP queries
• fa7b693 Enabled use of custom paging in DISTINCT queries [ #470 ]
• 5ec2bb2 Store all parameter values as INullable
• 72a28f8 Enable CUD operations on principalobjectaccess [ #423 ]
• f521c09 Added duplicate key error code mapping
• 0a2b862 Do not attempt to use DeleteMultiple except on elastic tables [ #469 ]

This list of changes was auto generated.

• 8bf0d19 Expose fragment details in error
• 52b6ac4 Report all internal errors with consistent error number
• 9be3726 Fixed NullReferenceException when retrieving results with an IN or EXISTS FetchXML subquery
• 357b839 Fixed NullReferenceException when an error is generated from TDS Endpoint
• 14a333d Handle converting query without CTE clause [ #462 ]

This list of changes was auto generated.

• 42a7f0f Do not attempt to fold IN/EXISTS queries to FetchXML for elastic or virtual tables
• b79d925 Merge pull request #455 from MarkMpn/executeas
• 3a96849 Made cached expressions collation sensitive
• 45ae277 Only apply truncation and collation conversion when necessary
• ac39dd0 Extra reflection helper
• 456a019 Improved handling of different parameter types for EXECUTE AS statement
• c691fcc Ensure impersonation was successful
• cee3566 Fixed infinite loop in TRY block
• b0fcb74 Extended validation of GROUP BY and EXECUTE AS expressions
• 87c7858 Merge pull request #454 from MarkMpn/executeas
• 0af0563 Fixed aggregate limit exception handling
• 748a3d0 Merge pull request #453 from MarkMpn/executeas
• 9a484e9 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
• 8e6c7f5 Updated error handling on string truncation
• 052d59c Merge pull request #452 from MarkMpn/executeas
• 2f929fa Merge branch 'master' into executeas
• f07fed0 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
• da4f63e Updated message formatting to match SSMS depending on severity
• 2a3bcbb Allow using RAISERROR with predefined error numbers
• 5c688bc Fixed constraint errors on system tables with null createdby attributes
• d019ee3 Merge pull request #451 from MarkMpn/executeas
• 3ba6987 Merge branch 'master' into executeas
• e65e592 Updated dependency version
• 260093d Merge pull request #450 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/tar-6.2.1
• c9d43f1 Bump tar from 6.1.11 to 6.2.1 in /AzureDataStudioExtension
• cd138d0 Merge pull request #448 from MarkMpn/executeas
• f7f9df9 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
• d8d30e3 Include error number in telemetry
• 0c6c776 Improved div by zero handling
• f0c19e1 Merge branch 'master' into executeas
• 75ade8c Updated Microsoft.Data.SqlClient package
• f6d883a Improved error reporting with TDS endpoint
• 3f68f18 Merge pull request #437 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/es5-ext-0.10.64
• 4e6e7aa Refactored error message generation
• e3a8be0 Merge branch 'master' into dependabot/npm_and_yarn/AzureDataStudioExtension/es5-ext-0.10.64
• e88048c Merge pull request #418 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.Engine.NetCore/System.Data.SqlClient-4.8.6
• 4a86ce7 Merge branch 'master' into dependabot/nuget/MarkMpn.Sql4Cds.Engine.NetCore/System.Data.SqlClient-4.8.6
• 3982f90 Merge pull request #415 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.SSMS.18/System.IdentityModel.Tokens.Jwt-6.34.0
• c72282e Merge branch 'master' into dependabot/nuget/MarkMpn.Sql4Cds.SSMS.18/System.IdentityModel.Tokens.Jwt-6.34.0
• 4dd1842 Merge pull request #414 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.LanguageServer/System.IdentityModel.Tokens.Jwt-6.34.0
• 93ef7e6 Merge branch 'master' into dependabot/nuget/MarkMpn.Sql4Cds.LanguageServer/System.IdentityModel.Tokens.Jwt-6.34.0
• 7e0165b Merge pull request #445 from MarkMpn/executeas
• 73762d3 Updated build configuration
• 915e328 Updated release notes
• 43f57de Fixed infinite loop
• 6775930 Avoid pulling more columns than necessary for subqueries
• c04b36c Avoid overwriting output of joins with values from right source in semi joins
• 426c60e Fixed handling of multiple child record filters
• bc29237 Updated release notes
• 641349d Added SSMS 20 support
• 223ac8f Merge pull request #435 from MarkMpn/executeas
• 32d7117 Improved null handling for NOT LIKE predicate
• 1977f0b Updated test to use useraworderby attribute
• 73642dd Fixed sorting on picklist names
• a5f0f0a Fixed filtering on virtual attributes where there are multiple virtual attributes for the same underlying lookup [ #443 ]
• 24f6125 Support
• 2978607 Handle converting sort orders on lookup and optionset fields to sort by name or value according to fetch useraworderby attribute
• 2c3d5c9 Use "retained" instead of "archive" for fetch datasource
• eb838c8 Support converting from new related record FetchXml filters to SQL
• c93a0be Added support for converting in/exists/matchfirstrowusingcrossapply links, and cross-table column comparison queries to SQL
• e770ec0 Do not re-fold queries inside conditional blocks [ #441 ]
• 7473251 Added "any" and "not any" link entity types
• d9a4f49 Moved feature availability flags to DataSource
• 3e79868 Support cross-table column comparison
• cd0a7b5 Refactored
• 0dc6ef3 Use attribute
• eea7e76 Bump es5-ext from 0.10.62 to 0.10.64 in /AzureDataStudioExtension
• 53ea676 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
• 067c485 Allow accessing catalog views using TDS Endpoint
• b499599 Merge pull request #433 from MarkMpn/executeas
• 2a58c1c Merge branch 'master' into executeas
• 9ee1297 Dapper compatibility
• e726127 TDS Endpoint doesn't support error handling functions or XML data type methods
• 3640602 Handle missing values in XML value method
• 3278cdb Bump System.Data.SqlClient in /MarkMpn.Sql4Cds.Engine.NetCore
• c6c6ae8 Merge pull request #430 from MarkMpn/executeas
• a62c677 Merged from master
• 7c11bef Improved query cancellation [ #63 ]
• d4717f0 Improved handling of errors from elastic tables
• 42df033 Expose warning on nested loops without join condition in execution plan view
• 6cb0700 Fold join condition on nested loop to the source nodes if it doesn't compare values between the two sources
• fb014aa Added support for rethrowing errors
• a19da3c Fixed using TOP 1 within IN clause [ #429 ]
• ff4310c Fixed NullReferenceException when folding nested loop with null outer references
• 04b968f Reduced query rewriting of select elements for improved performance
• 5968e34 Avoid creating Linq expressions where possible for improved performance
• d1f6217 Improved folding of multiple UNION statements
• b334568 Removed unnecessary usings
• edd5093 Avoid creating unnecessary lambda expressions
• 452d938 Avoid recalcu...

• 51aa85a Removed npm package lock file - install packages with yarn
• 09a2ac0 Updated node
• 55f2938 Simplified comment reformatting logic
• 79462c3 Added option to copy URL to record
• 8077808 Updated dependencies
• d70055d Updated release notes
• 4546d39 Updated dependencies
• f6ec7cc Fixed errors with CTE rewrites using alises in recursive references and unnecessary quotes in column references
• f7cd407 Preserve comments during formatting [ #393 ]
• e955970 Added "Yes To All" option for DML confirmation dialogs
• e04bf75 Fix partitioned aggregate error handling for dense data [ #387 ]
• 595fcd4 Improved handling of ambiguous column names from un-aliased TVFs
• 7d14f8e Find & Replace improvements
• 7d52cc7 Made OPENJSON handling of scalar values consistent with SQL Server
• 9670131 Made TVF display consistent in execution plan
• 6497d27 Added new files to project
• a336ee4 Added JSON_QUERY and ISJSON methods
• 0056a42 Added filter StartupExpression for more efficient filtering of CROSS APPLY queries
• 2535ab6 Fixed use of SELECT * within CTEs
• f3bd7f6 Fixed column name escaping
• 7c52cb2 Offer literal value suggestions for entityname attributes
• 3894c6b Handle setting polymorphic lookup fields using TDS Endpoint
• 588d0b1 Fixed use of OPENJSON in CROSS APPLY
• c7c5b81 Handle subquery alias as source for defined values in join
• 4c077ca Updated expected whitespace
• 3f87b05 Use System.Text.Json instead of Newtonsoft
• ccf8cec Added OPENJSON support using explicit schema
• 00d3d72 Added OPENJSON support using default schema [ #340 ]
• 915ee7c Add log message indicating IGNORE_DUP_KEY is implicit for listmember inserts
• 583d987 Apply naming convention
• 18f7f91 Avoid additional RetrieveVersionRequest where possible
• 49d0694 Added IGNORE_DUP_KEY query hint for insert commands
• ee540f9 Refactored outputting log messages from DML nodes
• a6b0237 Clearer progress messages for multi-threaded DML operations
• d4c8592 Remove data source from list when final use is disconnected
• cab37bd Show plugin error details in Azure Data Studio messages
• 1ed3d60 Fixed error showing execution plan with calculated columns
• 749b9e5 Do not fold NOT IN queries using an inner join to a left outer join [ #382 ]
• 624e423 Show plugin log more reliably
• 57af6c5 Avoid folding filters to tables in subqueries if the same alias exists in the outer query
• 604586c Switch FetchXML sort to custom sorting after adding joins that require custom paging
• 1770472 Reduce custom sorts on merge joins
• 1ca1381 Do not re-fold filter source immediately
• 45f89f1 Fold "under" and "above" filters to FetchXML
• 0237775 Fixed row count estimate overflow
• 6de3297 Handle time zone mismatch for starting bulk delete jobs [ #380 ]
• add2b61 Added tests for folding CTEs to hierarchical FetchXML conditions
• 7dee5fb Fixed test
• 1a1c177 Improved FetchXML to SQL conversion for hierarchical filters
• 9aaad16 Added missing files to NuGet package [ #377 ]
• 10aa0fb Support disconnect message from object explorer
• 17c2a73 Use standard Index Spool icon for custom Adaptive Index Spool node
• 9ae6aa7 Allow using columns from outer queries in joins [ #376 ]
• 9f4349b Check for multi-currency issues when aggregating non-base currency fields
• 06dac7b Allow rewriting CTEs used in subqueries
• a74a25b Improved folding CTE to FetchXML
• 41a0e3e Initial work on folding CTEs to FetchXML
• beff093 Spool large recursive queries
• 740580a Merged from master
• 9520643 Fixed nested loop left outer join with no records returned from inner source
• 8673a6a Merged from master
• 38fa3f1 Extended tests
• 203ac33 Fixed column renaming
• 165577d Use producer node as source
• efec67c Preserve WithStack property while cloning
• 07021a7 Keep aliases case insensitive
• 55acc58 Allow cloning joins
• d2e072f Recursion progress
• ca8c03f Merge remote-tracking branch 'origin/master' into cte
• e43617f Clone spool producer/consumer nodes
• 2fe11e9 Progress
• 95226dd Use MAXRECURSION hint
• b2382e7 Merge remote-tracking branch 'origin/master' into cte
• 180694d Build basic structure of recursive CTE plan
• 8e31b54 Added tests for calculated columns within CTE
• 9e4616a Tests for column aliases
• fb67a7e Validate CTEs before trying to convert them
• f0a8915 Updated error messages to match SQL Server
• b588229 Fixed UNION with wildcard columns
• 9137321 More simple tests
• c07a8cc Allow using TDS Endpoint for non-recursive CTEs
• f450304 Initial basic CTE implementation

This list of changes was auto generated.

• bac4793 Added option to reset tool windows [ #362 ]
• 18dea57 Allow updating many-to-many intersect tables [ #361 ]
• 5c108c0 Fixed use of SELECT * in subquery
• bd6b480 Added test for #360
• bbc1370 Improved error formatting for missing data sources
• d427392 Removed unnecessary checks for joins that have already been folded to data source
• 79780db Preserve additional join criteria when folding joins to MetadataQueryNode [ #360 ]
• 7a50a3c Improved folding NOT EXISTS to FetchXML
• 53fefbf Ensure only minimal schema is exposed by FetchXmlScan nodes regardless of execution order [ #359 ]

This list of changes was auto generated.

• 8c644e1 Fixed custom paging with alias on primary key field [ #346 ]
• c3fe6d9 Avoid errors getting unknown tables when we already know the query is not TDS-compatible
• b9470c3 Return correct schema for global option set values [ #345 ]
• 0fce22c Autocomplete variable names in SELECT clause without FROM

This list of changes was auto generated.

• 64ff050 Allow executing messages with OptionSetValue parameters
• b572fd1 Added option to use legacy SetState and Assign messages
• a314386 Fixed .NET Core build
• a494a04 Fixed uncorrelated TOP 1 scalar subquery
• 90c4ced Improved handling of floating windows
• 44594ea Added metadata for new properties
• 5b9be7c Load XTB assembly directly
• 048a00b Save dock layout
• 43fee7e Improved value returned for @@ServerName and SERVERPROPERTY('servername')
• fb00de5 Fixed returning schema for sql_variant values
• c2881aa Fixed error with rewriting nested loop joins if uncorrelated subquery result is used elsewhere other than the filte
• 166f51b Copy required files on debug builds
• 67083ac Improved autocomplete for variable names
• 8533b9f Added sql_variant support for SERVERPROPERTY function
• 628defe Expose @@Version and @@ServerName variables
• ff9e3df IS DISTINCT FROM improvements for column comparisons
• 8c5abc3 Support IS [NOT] DISTINCT FROM predicate
• 19312f5 Ensure subquery will only return 1 row before restructuring
• c1948fb Autocomplete collation names
• d008580 Use original logical name casing for FetchXML filters and sorts [ #337 ]
• 3b592ba Reorder uncorrelated subqueries for more efficient filtering [ #338 ]
• 742f07f Do not use merge join when data types do not have consistent sort orders
• b4f0d9a Handle nested IN & EXISTS subqueries
• 2b29bdc Limit data retrieved for scalar subqueries
• 610d2cf Do not use index spool for left side of nested loops, or where variable condition is from external parameter [ #338 ]
• 906d2f3 Do not attempt to convert ExecuteTransactionRequest to xxxMultiple requests [ #339 ]
• 852f964 More CROSS APPLY tweaks [ #330 ]
• e523e13 Cross apply progress [ #330 ]
• 9c2c9e3 Merge remote-tracking branch 'origin/master' into retention
• 06df106 Merge branch 'retention' of https://github.com/MarkMpn/Sql4Cds into retention
• 7f179d6 Updated minimum XTB version [ #334 ]
• e8cf5b6 Copy required files for debug
• 1ac4f46 Fixed JSON_VALUE getting a null literal [ #335 ]
• c0020a2 Fix getting values from a TVF with alias [ #330 ]
• 0ab6401 Fix cross-threading error with message box prompts

This list of changes was auto generated.