• 68bc69c Merged from master
• 82c97c8 Merge pull request #766 from MarkMpn/column-sorting
• 447e2f3 Fixed error attempting to display results of DML operations
• 177db7c Allow sorting results by clicking on column headers [ #764 ]
• 0e8df30 Bump tmp from 0.2.4 to 0.2.6 in /AzureDataStudioExtension
• 2d9867b Merge pull request #763 from MarkMpn/left-join-filter
• 68406b4 Merge branch 'left-join-filter' of https://github.com/MarkMpn/Sql4Cds into left-join-filter
• c0b25ed Updated release notes
• 6cafef4 Merge branch 'master' into left-join-filter
• 0cb338c Do not automatically add activitytypecode/partitionid for aggregate queries
• a97e3ee Merge pull request #758 from MarkMpn/results-as-text
• 3ae09a4 Merge branch 'master' into results-as-text
• f54d530 Merge pull request #760 from MarkMpn/statecode
• d3e00e2 Merge branch 'master' into statecode
• 6928ed6 Merge pull request #761 from MarkMpn/left-join-filter
• 1e98fb4 Allow folding single-outer-row joins to nested loops when the inner source is virtual [ #759 ]
• 72b1cf1 Include values from State and Status option value metadata [ #757 ]
• 301105d Allow showing results as text [ #729 ]
• b8cad1f Merge pull request #749 from sulimanbenhalim/add-round-function
• eef9775 Merged from master
• 5f1ef27 Use built-in SqlDecimal Round function
• abb17f0 Merge remote-tracking branch 'origin/master' into add-round-function
• fb58a04 Merge pull request #754 from MarkMpn/openrowset
• ca9cdcf Merge branch 'master' into openrowset
• 34998c3 Fixed handling of QueryExecutionException while building query plan [ #742 ]
• 7fc4707 Merge pull request #753 from MarkMpn/openrowset
• a266dc6 Line ending changes
• 2cdcf4e Merged from master
• aa4a540 Merge pull request #751 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/picomatch-2.3.2
• 8b9d97e Merge branch 'master' into dependabot/npm_and_yarn/AzureDataStudioExtension/picomatch-2.3.2
• 43f1625 Implemented filepath function
• fb6f583 Allow calling metadata functions on OPENROWSET results
• 08165cf Merge pull request #752 from MarkMpn/fix/743-expando-entity-json-serialization
• bd88445 Fix JSON serialization of nested Entity/EntityCollection in expando API responses [ #743 ]
• 5bced82 Error handling
• aafb8c0 Bump picomatch from 2.3.1 to 2.3.2 in /AzureDataStudioExtension
• bfa0fca Handle different terminators etc.
• 874b3ec Code page handling
• cfb5021 Add ROUND function with overloads for int, bigint, smallint, tinyint, decimal, float, real, and money types
• 2ef94ff Merge pull request #747 from sulimanbenhalim/add-floor-function
• 240049c FIRSTROW & LASTROW options
• 3a9bc96 Invalid filename error handling
• dff4bca Use source precision for FLOOR and CEILING methods
• 54689fe Merged from master
• 16c54f8 Merge pull request #746 from sulimanbenhalim/add-ceiling-function
• c1e5902 Fixed merge error
• b9ae11c Merged from master
• 3cef28e Merge pull request #745 from sulimanbenhalim/add-sign-function
• d40fa57 Add FLOOR function with overloads for all numeric types
• d1d680a Add CEILING function with overloads for all numeric types
• b9411e2 Add SIGN function with overloads for all numeric types
• 032fe25 Merge pull request #744 from sulimanbenhalim/add-abs-function
• d998721 Added overflow error handling
• 2646fc5 Added test for overload resolution and decimal precision
• dd2e47a Added more overloads
• 9039fb1 Fixed build
• 4c764a1 Return values with the correct precision and scale
• 60e3bcb Handle resolving multiple overloads of same function name
• 132aa0f Basic CSV reading
• 20834a3 Add ABS function for int, bigint, decimal, float, money, and real types
• e9ca9ea Fixed error generation
• 81a84a0 Preserve schema
• 39bebbc Fixed tests
• 4eb99db Implemented basic reading
• 8cdd76f Merge pull request #741 from MarkMpn/v10.3-fixes
• 2055fda Merge branch 'master' into v10.3-fixes
• a9b22ca Merge pull request #740 from MarkMpn/leftjoin-colname-escaping
• b8f0e70 Cache escaped column names
• 09659f0 Escape column names for aliased values as well as unaliased [ #739 ]
• a5ebd89 Initial parsing & error checking
• 4012fb8 Added OPENROWSET tests
• a0d05fa Improved error handling for unnamed and missing columns
• 24649ec Improved folding additional filters after extracting join criteria [ #738 ]

This list of changes was auto generated.

• 3f2c46e Merge pull request #730 from MarkMpn/ai-service
• cfb5dee Show details of supported models
• ed8f633 Use configurable list of models
• 9386d83 AI autocomplete improvements
• 99e6e53 Improved handling of AI autocomplete responses
• 0fb1ec8 Skip tests
• 9c42cb5 Merged from master
• b992a76 Updated release notes
• bd3b0a2 Updated gitignore
• 33461a8 Use public URL for sponsorship client
• b279192 Added manual credits override option
• c42e227 Improved button wrapping
• 277b5fc Fixed wrapping of buttons on mobile layout
• 0b8f53e Added option to regenerate API key
• 4377346 Merge pull request #728 from MarkMpn/ssms22
• 8dc5a27 Run EF Core migrations on startup
• 000c7a3 Fixed page title
• c2d94ae Added usage screenshot
• fd4bdb7 Implemented button to copy API key to clipboard
• 7643dec Updated organization credit limit
• 4800e77 Index fixes
• 4b096db Made hover effect more selective
• c6cc8a2 Improved display of credit counts
• 39d74ef Added info on organization sponsorship to home page
• e40e73b Ensure sponsorship is done as expected user
• 085b6d7 Show all organizations, not just sponsoring ones
• 22c00c8 Added info to settings page
• d83f16b Initial organization support
• a238f29 Added top-level link to dashboard. Redirect to login as necessary
• 37e01e7 Updated sponsorship levels. Charge different credits for different models
• 1ad0a41 Links
• 33de6e4 Styling
• 07a8df2 Hide sponsor CTA if already sponsoring
• f2b4125 Use Azure OpenAI backend
• 458c0c4 Added option for using sponsorship provider
• ad9b719 Refactored GitHub sponsorship check
• eff6c12 Fixed race condition
• 5482fbb Added index on ApiKey
• 9d4f862 Initial AI endpoint
• f6696b4 Show GitHub avatar
• 83871bd Highlighting
• 409ba13 Text update
• b7e7967 Fixed footer overlap
• a5d657a Added API key generation
• 0313a26 Show sponsorship details and allow refresh
• d2b5bce Get credits from sponsorship status
• 3271a46 Added database
• 76e112d Added GitHub OAuth
• b73b23d Initial layout
• 8a120d0 Fixed error when sorting results on virtual name attribute
• 603dc81 Tweaked system prompt
• 4646c2f Made AI autocomplete optional
• d91eff7 Tidying
• 5ade187 Improved user feedback
• a4a5b12 Allow stateful AI client
• 8e2ad73 Expose the validate_query tool
• 700825a Allow more reasoning effort for better responses
• 2b8930a Keep Cancel button enabled when looping over tool outputs
• 7faae82 AI autocomplete
• 2e1871a Tidying
• 278ca6e AI updates
• 06235c6 SSMS 22 compatibility

This list of changes was auto generated.

• f0a0ffc Fixed Ctrl+S shortcut [ #709 ]

This list of changes was auto generated.

• 8ea9e31 Added TRIM overloads
• 238b90c Updated XTB package
• 7a248c4 Merge pull request #700 from MarkMpn/coalesce
• 9c5ab54 Merge branch 'master' into coalesce
• 7b06f74 Merge pull request #699 from MarkMpn/ambiguous-table
• 83c7e61 Fixed use of COALESCE & other primary functions in variable assignments [ #698 ]
• 404d7ee Merge branch 'master' into ambiguous-table
• afa9de8 Merge pull request #691 from MarkMpn/ssms21
• cc72be0 Fixed resolving names for DML queries that reference the target table in the source query [ #693 ]
• 9963bcd Merge branch 'master' into ssms21
• dc9b636 Merge pull request #696 from MarkMpn/outerapply-filter
• 75c2a94 Merged from master
• 395ffbb Merge pull request #695 from MarkMpn/metadata
• 3ca36a2 Merged from master
• 62ce8b9 Merge pull request #692 from MarkMpn/binary-literal-filter-2
• e8863c8 Fixed primary key column description in optionset schema for improved row count estimation when joining to other tables
• f3ce801 Fold filters to inner side of outer joins for better performance
• 968bc54 Merge branch 'master' into binary-literal-filter-2
• 550c054 Merge pull request #694 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/tmp-0.2.4
• 69959c0 Ensure optionset primary key columns are flagged as not null
• 4b61191 Set up metadata query even if no properties are being requested from it [ #690 ]
• d6246dd Bump tmp from 0.2.1 to 0.2.4 in /AzureDataStudioExtension
• 6037a8c Convert binary literals to bigint for use in FetchXML
• 9e1d545 Publish vsix instead of msi for SSMS21
• 5daf5c2 Merge pull request #686 from sulimanbenhalim/sulimanbenhalim-minicharteditor-possible-crash-fix
• 6c06bc6 Fix possible crash in MiniChartEditor

This list of changes was auto generated.

• 82a1051 Do not spool OPENJSON results [ #682 ]
• 89c6983 Moved ScriptDom debugger to separate repo
• b7d08a7 Handle AND/OR within NOT [ #677 ]
• 6e29dda Removed commented code
• 92c4095 Load message and recycle bin metadata in background for smoother autocomplete
• 456cf55 Avoid conflicts between DISTINCT, TOP and aggregates [ #679 ]
• 509667a Fixed use of DISTINCT with subqueries [ #676 ]
• 08ff649 Binary data type conversions
• 2e46652 Expose versionnumber column using RowVersion from retrieved entity and convert to same binary format as used by SQL Server [ #678 ]
• 0f9ad09 Enabled use of CTEs in INSERT statements [ #596 ]
• edb5b82 Allow use of CTEs in DELETE and UPDATE statements
• 89c5801 Added ScriptDom serializers to solution
• aad8b02 Fixed use of null values in execution plan serializer
• 34f76c3 Fixed compile error
• 00c20e4 Allow targeting subqueries in UPDATE statements
• 077528f Added visualizer support for all new node types
• f745200 New debug visualiser for ScriptDom
• 093c049 Fixed stack overflow exception when using custom FetchXML datetime conditions
• b2d82ff Allow deleting from subquery
• f941baf Handle duplicated column names from TDS endpoint for DML operations [ #670 ]
• c05db00 Fixed inserting null literal values into temp tables
• f0c6bb5 Expose source table/column details for output columns
• 3975596 Fixed test
• d8ca9a7 Fixed inserting into principalobjectaccess [ #674 ]
• 7148aec Do not expose name and type virtual attributes if they already exist as physical attributes
• e0bbb93 Handle duplicate connection error in same way as other duplicate key errors [ #672, #6 ]
• dbee262 Wildcard handling improvements
• 7ab7e35 Merge branch 'v9.6-fixes' of https://github.com/MarkMpn/Sql4Cds into v9.6-fixes
• 12b8abf Improved error handling for DROP TABLE IF EXISTS [ #664 ]

This list of changes was auto generated.

• 0841f1e Fixed DML operations on listmember [ #655 ]
• a094ec6 Do not use TDS Endpoint for temporary tables [ #663 ]
• c4a5e79 Added support for more alphanumeric datetime formats [ #657 ]
• 9a4ea9b Check links to be added for IN/EXISTS predicates are valid before making other changes to the query [ #649 ]
• ff1e2a4 Fixed arithmetic overflow when adding large row count estimates in Concatenate node [ #651 ]
• d3aa29d Updated copyright notice
• d633e08 Do not attempt to restore connections using SDK login control [ #647 ]
• ae256ab Fixed label on checkbox to restore sessions with the original connection
• 344b781 Fixed showing the "Confirm close" dialog individually for each tab after already selecting "No" on the same dialog for bulk closing tabs
• 621bb67 Fixed inserting a primary key value from an existing lookup value [ #643 ]
• 9660f3f Always include audit.objectid when including audit.changedata to ensure all data is included [ #644, #646 ]

This list of changes was auto generated.