| |
| Date | Build
Number | Change
Type | Description |
| 10/06/2025 | 9410 | General | Added
- Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
|
| 09/22/2025 | 9396 | Shopify | Added
- Added support for filtering the Discounts tables using the EndsAt, CreatedAt, and UpdatedAt columns.
- Added support for INSERT, UPDATE, and DELETE operations on the CustomerAddresses table.
- Added support for filtering the Articles table using the BlogId, Handle, and PublishedAt columns.
- Added support for filtering the Pages table using the PublishedStatus, PublishedAt, and Id columns.
- Added support for filtering the ArticleComments table using the CreatedAt, UpdatedAt, and PublishedAt columns.
- Added the OrderCreateManualPayment stored procedure with Amount, CurrencyCode, OrderId, and PaymentMethod inputs.
- Added support for filtering the Collections, Orders, Locations, and Products tables using the Key, Namespace, and Value columns.
- The Collections and Products tables supports filtering using the Handle column.
|
| 09/15/2025 | 9389 | Shopify | Added
- Added the Scope connection property.
|
| 09/12/2025 | 9386 | General | Added
- Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
|
| 09/10/2025 | 9384 | General | Changed
- All columns in statically defined Views are now reported as read-only.
|
| 09/03/2025 | 9377 | General | Changed
- Corrected the behavior when IN criteria with NULL values are used in the projection part. It now returns NULL instead of 0. For example, "NULL IN (1,2)" returns "NULL".
|
| 09/01/2025 | 9375 | General | Added
- Added support for using the CAST function with infinity values. This function can cast "inf" and "-inf" to DOUBLE, FLOAT, or REAL.
|
| 08/29/2025 | 9372 | Shopify | Added
- Added the REST-2025-04 schema.
- Added the GRAPHQL-2025-04 schema.
- Added the RequiresShippingMethod column to the FulfillmentServices table for SELECT, INSERT, and UPDATE operations in the GRAPHQL Data Model.
- Added the Fee and Net columns to the ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders table in the GRAPHQL Data Model.
- Added the RecurringPricingPlanHandle column to the AppSubscriptionLineItems table in the GRAPHQL Data Model.
- Added the Role column for INSERT operations on the Themes table in the GRAPHQL Data Model.
- Added the SmsMarketingConsentSourceLocationId and EmailMarketingConsentSourceLocationId columns to the Customers table in the GRAPHQL Data Model.
- Added the Fee and Net columns to the PayoutTransactionsAdjustmentOrderTransactions table in the REST Data Model.
|
| 08/22/2025 | 9365 | Shopify | Added
- Added the GRAPHQL-2025-01 schema.
- Added the REST-2025-01 schema.
Removed
- Removed the AccountNumer and RoutingNumber columns from the ShopifyPaymentsAccountBankAccounts table.
|
| 08/21/2025 | 9364 | General | Changed
- Report behavior change:
- Fixed inconsistent string value comparisons in non-table queries.
- For example, "SELECT 'A' = 'a'" previously returned false, but it now returns true.
|
| 08/13/2025 | 9356 | General | Changed
- Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
|
| 07/08/2025 | 9320 | Shopify | Added
- Added PointsBufferSize as a connection property. This property specifies the size of a point buffer used to increase the calculated wait time. Setting this property can help to prevent API throttling.
|
| 07/07/2025 | 9319 | Python | Removed
- Removed the 32-bit version of Windows Python.
|
| 07/02/2025 | 9314 | Python | Removed
- Removed support for Python 3.9.
|
| 07/02/2025 | 9314 | Shopify | Added
- Added server-side filtering support for the OrderID column in the FulfillmentOrders table.
|
| 06/26/2025 | 9308 | Shopify | Added
- Added the LocationInventoryQuantity filter to the ProductVariants view in all GRAPHQL schemas.
- Added the Source column to the following views: AbandonedCheckoutTaxLines, DraftOrderLineItemTaxLines, DraftOrderTaxLines, FulfillmentLineItemTaxLines, OrderLineItemTaxLines, and OrderTaxLines in the GRAPHQL-2024-10 schema.
- Added the DeliveryMethodPresentedName and DestinationLocationId columns to the AssignedFulfillmentOrders and FulfillmentOrders views in the GRAPHQL-2024-10 schema.
- Added the BuyerExperienceConfigurationEditableShippingAddress and BuyerExperienceConfigurationDepositPercentage columns to the CompanyLocations view in the GRAPHQL-2024-10 schema.
- Added the AppliesOnSubscription and RecurringCycleLimit columns to the DiscountsAutomaticApp view in the GRAPHQL-2024-10 schema.
- Added the DutiesIncluded, StatusPageUrl, MerchantBusinessEntityId, TotalCashRoundingAdjustmentPaymentSetPresentmentMoneyAmount, TotalCashRoundingAdjustmentPaymentSetPresentmentMoneyCurrencyCode, TotalCashRoundingAdjustmentPaymentSetShopMoneyAmount, TotalCashRoundingAdjustmentPaymentSetShopMoneyCurrencyCode, TotalCashRoundingAdjustmentRefundSetPresentmentMoneyAmount, TotalCashRoundingAdjustmentRefundSetPresentmentMoneyCurrencyCode, TotalCashRoundingAdjustmentRefundSetShopMoneyAmount, and TotalCashRoundingAdjustmentRefundSetShopMoneyCurrencyCode columns to the Orders view in the GRAPHQL-2024-10 schema.
- Added the AmountRoundingSetPresentmentMoneyAmount, AmountRoundingSetPresentmentMoneyCurrencyCode, AmountRoundingSetShopMoneyAmount, AmountRoundingSetShopMoneyCurrencyCode, PaymentDetailsLocalPaymentDescriptor, PaymentDetailsLocalPaymentMethodName, PaymentDetailsShopPayInstallmentsPaymentMethodName, PaymentDetailsCardAvsResultCode, PaymentDetailsCardBin, PaymentDetailsCardCompany, PaymentDetailsCardCvvResultCode, PaymentDetailsCardExpirationMonth, PaymentDetailsCardExpirationYear, PaymentDetailsCardName, PaymentDetailsCardNumber, PaymentDetailsCardPaymentMethodName, and PaymentDetailsCardWallet columns to the OrderTransactions view in the GRAPHQL-2024-10 schema.
- Added the PublicationId, VariantId, and VariantTitle filters to the Products view in the GRAPHQL-2024-10 schema.
- Added the UnitPriceMeasurementMeasuredType, UnitPriceMeasurementQuantityUnit, UnitPriceMeasurementQuantityValue, UnitPriceMeasurementReferenceUnit, and UnitPriceMeasurementReferenceValue columns to the ProductVariants view in the GRAPHQL-2024-10 schema.
- Added the OwnerName column to the Shop view in the GRAPHQL-2024-10 schema.
- Added the BusinessEntityId, SummaryAdvanceFeesAmount, SummaryAdvanceFeesCurrencyCode, SummaryAdvanceGrossAmount, and SummaryAdvanceGrossCurrencyCode columns to the ShopifyPaymentsAccountPayouts view in the GRAPHQL-2024-10 schema.
- Added the AccountType column to the StaffMembers view in the GRAPHQL-2024-10 schema.
- Added the OrderId column to the TenderTransactions view in the GRAPHQL-2024-10 schema.
- Added the DeliveryMethodId, DeliveryMethodPresentedName, and DeliveryMethodType columns to the AssignedFulfillmentOrders and FulfillmentOrders views in the REST-2024-10 schema.
- Added the MerchantBusinessEntityId column to the Orders view in the REST-2024-10 schema.
- Added the AmountRounding column to the OrderTransactions view in the REST-2024-10 schema.
|
| 06/25/2025 | 9307 | General | Removed
- Removed the "ADLS Gen 1" value from the ConnectionType property.
|
| 06/25/2025 | 9307 | Python | Added
- Added support for Python 3.13 in Windows, Linux, and Mac editions.
Removed
- Removed support for Python 3.8 as it is no longer supported.
|
| 06/23/2025 | 9305 | Shopify | Removed
- Removed the following schemas: REST-2023-04, REST-2023-07, REST-2023-10, REST-2024-01, GRAPHQL-2023-04, GRAPHQL-2023-07, GRAPHQL-2023-10, and GRAPHQL-2024-01.
|
| 06/20/2025 | 9302 | General | Added
- Created the following functions:
- TEXT_ENCODE: encodes a string into a different charset (UTF8 → UTF7 and returns a binary array as the result).
- TEXT_DECODE: takes a binary array and decodes it back into a string when provided the charset.
- BASE64_ENCODE: takes a binary array and encodes it as a base64 string (varchar).
- BASE64_DECODE: takes a base 64-encoded string and decodes it into a binary array.
|
| 06/18/2025 | 9300 | General | Changed
- The internal code for exception handling has been refactored. Exception messages returned during certain error conditions may now have different wording or formatting.
|
| 05/28/2025 | 9279 | Shopify | Changed
- The FulfillmentOrders view's status column now supports filtering by OPEN, CLOSED, CANCELLED, IN_PROGRESS, INCOMPLETE, ON_HOLD, and SCHEDULED.
- The FulfillmentOrders view now also returns CLOSED FulfillmentOrders when executing a SELECT query. This is a breaking change.
|
| 05/27/2025 | 9278 | General | Removed
- Removed the "Proprietary" enum option from ProxyAuthscheme.
|
| 05/16/2025 | 9267 | Shopify | Added
- Added the InventoryMoveQuantities, InventoryAdjustQuantities, and InventoryBulkToggleActivation stored procedures to the GRAPHQL-2023-04, GRAPHQL-2023-07, GRAPHQL-2023-10, GRAPHQL-2024-01, GRAPHQL-2024-04, GRAPHQL-2024-07 and GRAPHQL-2024-10 schemas.
- Added the InventorySetScheduledChanges stored procedure to the GRAPHQL-2024-01, GRAPHQL-2024-04, GRAPHQL-2024-07 and GRAPHQL-2024-10 schemas.
- Added the InventorySetQuantities stored procedure in the GRAPHQL-2024-07 and GRAPHQL-2024-10 schemas.
- Added the InventoryAdjustmentGroups and InventoryAdjustmentGroupChanges views to the GRAPHQL-2023-04, GRAPHQL-2023-07, GRAPHQL-2023-10, GRAPHQL-2024-01, GRAPHQL-2024-04, GRAPHQL-2024-07, and GRAPHQL-2024-10 schemas.
- Added the InventoryItemInventoryLevelScheduledChanges view to the GRAPHQL-2024-01, GRAPHQL-2024-04, GRAPHQL-2024-07, and GRAPHQL-2024-10 schemas.
- Added support for INSERT and DELETE to the InventoryItemInventoryLevels table in the GRAPHQL-2023-04, GRAPHQL-2023-07, GRAPHQL-2023-10, GRAPHQL-2024-01, GRAPHQL-2024-04, GRAPHQL-2024-07, and GRAPHQL-2024-10 schemas.
- Added the InventoryItemId column to the InventoryItemInventoryLevelQuantities view in the GRAPHQL-2024-04, GRAPHQL-2024-07, and GRAPHQL-2024-10 schemas.
|
| 05/13/2025 | 9264 | Shopify | Added
- Added the TrackingInfoCompany column to the Fulfillments table in the GRAPHQL 2024-10 schema.
- Added the following tables to the GRAPHQL 2024-07 and GRAPHQL 2024-10 schemas: Menus, StoreCreditAccountCreditTransactions, and StoreCreditAccountDebitTransactions.
- Added the following views to the GRAPHQL 2024-07 and GRAPHQL 2024-10 schemas: CustomerStoreCreditAccounts, LocalizationCountries, ProductBundleComponentOptionSelections, ProductBundleComponents, ProductOperations, StoreCreditAccountDebitRevertTransactions, and StoreCreditAccountExpirationTransactions.
- Added input BundleComponents to the Products table and added support for creating and updating componentized products in the GRAPHQL 2024-07 and GRAPHQL 2024-10 schemas.
- Added DELETE support for the Orders table in the GRAPHQL 2024-07 and GRAPHQL 2024-10 schemas.
- Added INSERT/UPDATE/DELETE support for the CarrierServices view in the GRAPHQL 2024-10 schema.
|
| 05/12/2025 | 9263 | Python | Changed
- Updated embedded JRE to jre-17.0.15+6 (Linux x64 / MacOS x64) and jre-17.0.15+6 (MacOS aarch64).
|
| 05/07/2025 | 9258 | Shopify | Added
- Added the OrderLineItemTaxLines view to all versions of GRAPHQL.
- Added the OrderShippingLines, AbandonedCheckouts, AbandonedCheckoutTaxLines, and AbandonedCheckoutCustomAttributes views to the GRAPHQL-2024-10 schema.
- Added server-side count support for the Collections, Companies, Customers, and UrlRedirects tables for all versions of the GRAPHQL schema.
- Added server-side count support for the ProductVariants table in the REST 2023-04, 2023-07, 2023-10, and 2024-01 schemas.
- Added server-side count support for the Events view for all versions of the GRAPHQL schemas.
- Added server-side count support for the Blogs view in the GRAPHQL 2023-04, 2023-07, 2023-10, 2024-01, 2024-04, and 2024-07 schemas.
- Added server-side count support for the Blogs table in GRAPHQL and in REST 2023-04, 2023-07, 2023-10, REST 2024-01, 2024-04, 2024-07, and REST 2024-10 schemas.
- Added server-side count support for the DraftOrders table in all GRAPHQL and REST schema versions.
- Added server-side count support for the Orders table in all GRAPHQL and REST schema versions.
- Added server-side count support for the GiftCards table in all GRAPHQL and REST schema versions.
- Added server-side count support for the Pages table in the REST 2023-04, REST 2023-07, REST 2023-10, REST 2024-01, REST 2024-04, REST 2024-07 schemas, in both GRAPHQL and REST 2024-10 schemas.
- Added server-side count support for the Products table in both the GRAPHQL and REST 2023-04, 2023-07, 2023-10, 2024-01 schemas.
- Added server-side count support for the Products table in the GRAPHQL 2024-04, 2024-07, and 2024-10 schemas.
- Added NotifyCustomer and Message inputs for the INSERT operation in the Fulfillments table.
- Added the InventoryAction pseudo-column for the DELETE operation to the FulfillmentServices table. When deleting a service, the LocationId column can be specified to determine a destination location for the inventory.
- Added support for deactivating gift cards by updating the Enabled column.
- Added the following columns to the GiftCards table: DeactivatedAt, RecipientAttributesRecipientId, RecipientAttributesPreferredName, RecipientAttributesMessage, RecipientAttributesSendNotificationAt, and UpdatedAt.
- Added CreateVariantStrategy input for the INSERT operation in the ProductOptions table.
- Added the UserId column to the OrderTransactions table.
- Added support for the INSERT operation and corresponding inputs for the Orders table.
- Added the Number column to the Orders table.
- Added server-side filtering support for CurrentSubtotalLineItemsQuantity in the Orders table.
Changed
- Changed the State and FeedbackGeneratedAt pseudo-columns to columns in the AppFeedbacks table.
Deprecated
- Deleting gift cards is deprecated.
|
| 04/30/2025 | 9251 | Shopify | Added
- Defined a composite key (RefundId and LineItemId) for the RefundLineItems view (GRAPHQL-2023-04 to GRAPHQL-2024-04).
- Added an Id column as the primary key for the RefundLineItems view (GRAPHQL-2024-07 and later).
Changed
- CarrierServices.Id is now a primary key (all GRAPHQL schemas).
- MetaobjectDefinitions.ID is now a primary key (all GRAPHQL schemas).
|
| 04/22/2025 | 9243 | Shopify | Added
- In the 2024-07 and 2024-10 schemas, added the Active, SupportsServiceDiscovery, and CallbackUrl columns to the CarrierServices view.
- In the 2024-07 and 2024-10 schemas, added the DefaultAddressValidationResultSummary column to the Customers table.
- In the 2024-07 and 2024-10 schemas, added the DefaultAddressValidationResultSummary column to the CustomerSegmentMembers view.
- In the 2024-07 and 2024-10 schemas, added the BillingAddressValidationResultSummary and ShippingAddressValidationResultSummary columns to the DraftOrders table.
- In the 2024-07 and 2024-10 schemas, added the CreatedAt column to the FulfillmentEvents table.
- In the 2024-07 and 2024-10 schemas, added the VariantID column to the FulfillmentOrderLineItems view.
- In the 2024-07 and 2024-10 schemas, added the VariantID column to the FulfillmentOrderLocationForMoveAvailableLineItems view.
- In the 2024-07 and 2024-10 schemas, added the VariantID column to the FulfillmentOrderLocationForMoveUnavailableLineItems view.
- In the 2024-07 and 2024-10 schemas, added the TrackingSupport column to the FulfillmentServices table.
- In the 2024-07 and 2024-10 schemas, added the SourceName, FulfillmentsCount, FulfillmentsCountPrecision, StaffMemberId, DisplayAddressValidationResultSummary, BillingAddressValidationResultSummary, and ShippingAddressValidationResultSummary columns to the Orders table.
- In the 2024-07 and 2024-10 schemas, added the FinalCapture input to the OrderTransactions table.
- In the 2024-07 and 2024-10 schemas, added the AppliedDiscountValueAmountCurrencyCode, AppliedDiscountValuePercentage, AppliedDiscountDescription, and GiftCardCodes inputs to the ReturnExchangeLineItems view.
- In the 2024-07 and 2024-10 schemas, added the ReturnExchangeLineItems column to the Returns table.
- In the 2024-07 and 2024-10 schemas, added the Metafields input to the SellingPlanGroupSellingPlans view.
- In the 2024-07 and 2024-10 schemas, added the SourceId, SourceOrderTransactionId, and AdjustmentReason columns to the ShopifyPaymentsAccountBalanceTransactions view.
|
| 04/01/2025 | 9222 | Shopify | Added
- Added the OrderUpdatedAt column to the OrderLineItems view in the GraphQL schema.
|
| 03/19/2025 | 9209 | Shopify | Added
- Added the following tables to the GRAPHQL-2024-10 schema: Articles, ArticleComments, Blogs, CompanyLocationStaffMemberAssignments, GiftCardTransactionsCredit, GiftCardTransactionsDebit, MetafieldDefinitions, Pages, and Themes.
- Added the following views to the GRAPHQL-2024-10 schema: ArticleEvents, ArticleCommentEvents, BusinessEntities, BlogEvents, CustomerAddresses, Disputes, Events, MetafieldDefinitionConstraintValues, MetafieldDefinitionStandardTemplates, MetafieldDefinitionTypes, PageEvents, ProductEvents, ProductVariantEvents, RefundOrderAdjustments, RefundShippingLines, ReturnLineItemsUnverified, ReverseFulfillmentOrders, ReverseFulfillmentOrderDeliveries, ReverseFulfillmentOrderDeliveryLineItems, and ReverseFulfillmentOrderLineItems.
- Added the following stored procedures to the GRAPHQL-2024-10 schema: ApproveComment, EnableStandardMetafieldDefinition, MarkCommentNotSpam, MarkCommentSpam, and PublishTheme.
- Added the following column to the Metafields table in the GRAPHQL-2024-10 schema: DefinitionId.
- Added article, blog, and page as filtering options in the OwnerResource column of the Metafields table in the GRAPHQL-2024-10 schema.
- Added the following view to the GRAPHQL-2024-07 schema: ReturnLineItemsUnverified.
- Added the following columns to the Products table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: AvailablePublicationCountPrecision and MediaCountPrecision.
- Added the following columns to the Shop view in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: PublicationCountPrecision, PrimaryDomainMarketWebPresenceDefaultLocaleMarketWebPresencesId, PrimaryDomainMarketWebPresenceDefaultLocaleName, PrimaryDomainMarketWebPresenceDefaultLocalePrimary, and PrimaryDomainMarketWebPresenceDefaultLocalePublished.
- Added the following columns to the Collections table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: AvailablePublicationCountPrecision and ProductsCountPrecision.
- Added the following columns to the Companies table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: ContactCountPrecision, LocationCountPrecision, and OrderCountPrecision.
- Added the following column to the DeliveryProfileLocationGroups view in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: LocationsCountPrecision.
- Added the following column to the DiscountsCodeApp table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: CodeCountPrecision.
- Added the following column to the DiscountsCodeBasic table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: CodeCountPrecision.
- Added the following column to the DiscountsCodeBxgy table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: CodeCountPrecision.
- Added the following column to the DiscountsCodeFreeShipping view in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: CodeCountPrecision.
- Added the following columns to the FulfillmentOrderLocationsForMove view in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: AvailableLineItemsCountPrecision and UnavailableLineItemsCountPrecision.
- Added the following column to the InventoryItems table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: LocationsCountPrecision.
- Added the following column to the Orders table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: CustomerJourneySummaryMomentsCountPrecision.
- Added the following column to the SellingPlanGroups table in the GRAPHQL-2024-01, GRAPHQL-2023-10, GRAPHQL-2023-07, and GRAPHQL-2023-04 schemas: ProductCountPrecision.
|
| 03/07/2025 | 9197 | Shopify | Added
- Added the following views to all GraphQL schemas: FulfillmentLineItems and FulfillmentLineItemTaxLines.
|
| 02/19/2025 | 9181 | Shopify | Added
- Added the GRAPHQL-2024-10 and REST-2024-10 schemas.
Removed
- Removed the following view from the GRAPHQL schema: ShopifyPaymentsAccountPermittedVerificationDocuments.
- Removed the following views from the GRAPHQL schema: Articles, ArticleComments, Blogs, and Pages.
- Removed the following column from the SendFulfillmentRequest stored procedure in the GRAPHQL schema: ShippingMethod.
- Removed the following column from the GiftCards table in the GRAPHQL schema: DisabledAt.
- Removed the following columns from the Shop view in the GRAPHQL schema: FeaturesAvalaraAvatax, FeaturesBranding, FeaturesCaptcha, FeaturesDynamicRemarketing, FeaturesHarmonizedSystemCode, FeaturesLiveView, FeaturesReports, and FeaturesShowMetrics.
- Removed the following columns from the ShopifyPaymentsAccount view in the GraphQL schema: FraudSettingsDeclineChargeOnAvsFailure, FraudSettingsDeclineChargeOnCvcFailure, and NotificationSettingsPayouts.
- Removed the following columns from the AbandonedCheckouts view in the REST schema: CartToken, ClosedAt, Currency, LandingSite, ReferringSite, Token, TotalWeight, and SourceName.
- Removed the following columns from AbandonedCheckoutsItems view in the REST schema: ItemGrams and FulFillmentsService.
Changed
- The Id field is required for the ShopifyPaymentsAccountVerifications view in the GRAPHQL schema.
|
| 02/15/2025 | 9177 | General | Added
- Added support for converting unsigned integer types to the nearest signed data type that has enough precision to hold the unsigned value.This is done for JDBC only because it does not have support for unsigned data types.
|
| 02/13/2025 | 9175 | Shopify | Added
- Added the following tables: CompanyContacts, CompanyContactRoles, and CompanyContactRoleAssignments.
- Added support for updating the MainContactId column in the Companies table.
|
| 01/06/2025 | 9137 | Shopify | Added
- Added support for API Version 2024-07 which corresponds to the following new schemas: GRAPHQL-2024-07 and REST-2024-07.
- Added the RetailLocationId column to the Orders table for schema GRAPHQL-2024-07.
- Added the AdjustmentReason column to the PayoutTransactions view for schema REST-2024-07.
- Added the DiscountCodes, AcceptAutomaticDiscounts, AllowDiscountCodesInCheckout, Warnings, and PlatformDiscountIds columns to the DraftOrder table for schema GRAPHQL-2024-07.
- Added INSERT/UPDATE support for the DiscountCodes, AcceptAutomaticDiscounts, and AllowDiscountCodesInCheckout columns in the DraftOrder table for schema GRAPHQL-2024-07.
- Added the DeliveryMethodSourceReference column to the FulfillmentOrders and AssignedFulfillmentOrders tables for schema GRAPHQL-2024-07.
- Added the SourceType, Type, Test, Amount, AmountCurrencyCode, FeeAmount, FeeCurrencyCode, AssociatedOrderId, AssociatedOrderName, AssociatedPayoutId, and AssociatedPayoutStatus columns to the ShopifyPaymentsAccountBalanceTransactions view for schema GRAPHQL-2024-07.
- Added the Files table for schema GRAPHQL-2024-07.
- Added the CreateFile and UpdateFile stored procedures for schema GRAPHQL-2024-07.
- Added the selling_plan enum value for the Metafields table's OwnerResource filter column for schema GRAPHQL-2024-07.
Changed
- Changed the default schema to GRAPHQL-2024-07. The REST API is marked as legacy by Shopify.
Removed
- Removed tables Countries and Provinces for schema REST-2024-07.
|
| 11/27/2024 | 9097 | General | Added
- Added ThreadId to LogModule output. Logfile lines now include the Thread ID associated with the action being performed.
|
| 10/31/2024 | 9070 | Shopify | Added
- Added support for the API version 2024-04, which corresponds to two new schemas in Shopify (GraphQL-2024-04 and REST-2024-04).
|
| 10/07/2024 | 9046 | Shopify | Removed
- Removed the AverageOrderAmountV2Amount and AverageOrderAmountV2CurrencyCode columns from the GraphQL-2023-04.Customers and GraphQL-2023-07.Customers tables.
- Removed the ResourceLimitsSkuResourceLimitsAvailable, ResourceLimitsSkuResourceLimitsQuantityAvailable, ResourceLimitsSkuResourceLimitsQuantityLimit, and ResourceLimitsSkuResourceLimitsQuantityUsed columns from the GraphQL-2023-04.Shop and GraphQL-2023-07.Shop views.
|
| 08/16/2024 | 8994 | Shopify | Added
- Added 34 new views related to Segments, OrderAgreements, OrderEditAgreements, and OrderRefundAgreements to all GRAPHQL schemas.
- Added the Segments table to all GRAPHQL schemas.
|
| 06/05/2024 | 8922 | Python | Added
- Added support for Python 3.12.
|
| 05/09/2024 | 8895 | General | Changed
- The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 04/15/2024 | 8871 | Shopify | Added
- Added schema GraphQL-2024-01 and REST-2024-01.
- Added FulfillmentOrderLineItems, FulfillmentOrderLocationsForMove, PriceListPrices as tables (GraphQL 2023-07, 2023-10, 2024-01).
- Added AccessAdmin, AccessStorefront, CapabilitiesPublishableEnabled, CapabilitiesTranslatableEnabled as columns to MetaobjectDefinitions (GraphQL 2023-07, 2023-10, 2024-01).
- Added DefinitionId, TypeField, CapabilitiesPublishableStatus as columns to MetaObjects (GraphQL 2023-07, 2023-10, 2024-01).
- Added CapabilitiesOnlineStoreTemplateSuffix as a column to MetaObjects (GraphQL 2023-10, 2024-01).
- Added CapabilitiesOnlineStoreEnabled, CapabilitiesOnlineStoreDataCanCreateRedirects, CapabilitiesOnlineStoreDataUrlHandle, CapabilitiesRenderableEnabled, CapabilitiesRenderableDataMetaDescriptionKey, CapabilitiesRenderableDataMetaTitleKey as columns to MetaobjectDefinitions (GraphQL 2023-10, 2024-01).
- Added AbandonedCheckoutLineItems, ShopifyPaymentsAccountBalanceTransactions, ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders, FulfillmentOrderLocationForMoveAvailableLineItems, FulfillmentOrderLocationForMoveUnavailableLineItems as tables (GraphQL 2024-01).
- Added OrderCancel as a stored procedure (GraphQL 2024-01).
- Added ThumbnailFieldKey, ThumbnailFieldThumbnailHex, ThumbnailFieldFileId, ThumbnailFieldFileAlt, ThumbnailFieldFileCreatedAt, ThumbnailFieldFileUpdatedAt, ThumbnailFieldFileFileStatus, ThumbnailFieldFileFileErrors, ThumbnailFieldFilePreviewStatus, ThumbnailFieldFilePreviewImageId, ThumbnailFieldFilePreviewImageAltText, ThumbnailFieldFilePreviewImageHeight, ThumbnailFieldFilePreviewImageWidth, ThumbnailFieldFilePreviewImageUrl as columns to MetaObjects (GraphQL 2024-01).
- Added MultiCapturable as a column to OrderTransactions and RefundTransactions (GraphQL 2024-01).
- Added PayoutTransactionsAdjustmentOrderTransactions as a table (REST 2024-01).
- Added CurrentQuantity as a column to OrdersItems (REST 2024-01).
- Added FinancialSummaries as a column to FulfillmentOrderLineItems (GraphQL 2024-01, REST 2024-01).
- Added MediaId and MediaSrc as inputs to ProductVariants (GraphQL 2024-01).
Changed
- Changed ProductImages table's name to ProductMediaImages (GraphQL 2024-01).
Removed
- Removed ResourceLimitsSkuResourceLimitsAvailable, ResourceLimitsSkuResourceLimitsQuantityAvailable, ResourceLimitsSkuResourceLimitsQuantityLimit, ResourceLimitsSkuResourceLimitsQuantityUsed (GraphQL 2023-10).
- Removed AcceptsMarketing column from Customers (GraphQL 2024-01).
|
| 03/20/2024 | 8845 | Shopify | Added
- Added FulfillmentOrderLineItems as a table in the REST-2023-04, REST-2023-07, and REST-2023-10 schema.
|
| 03/15/2024 | 8840 | General | Added
- Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
|
| 02/27/2024 | 8823 | Shopify | Added
- Added ConfirmationNumber as a column to the Orders table in the REST-2023-07, REST-2023-10, GRAPHQL-2023-07 and GRAPHQL-2023-10 schema.
- Added PresentmentPrices, PresentmentAmount, PresentmentCurrency, CompareAtPriceAmount, CompareAtPriceCurrency columns to ProductVariants table.
|
| 02/20/2024 | 8816 | Shopify | Added
- Added support for API version 2023-10.
- Table Location in the GraphQL schema and the 2023-10 version now has CUD support.
- Added two new columns OrderName and OrderProcessedAt for the FulfillmentOrders table (GraphQL schema, 2023-10 version).
Removed
- Removed deprecated column AverageOrderAmountV2Amount and AverageOrderAmountV2CurrencyCode from the Customers table (GraphQL schema, 2023-10 version).
- Removed deprecated column BillingOn from the UsageCharges table (REST schema, 2023-10 version).
|
| 01/25/2024 | 8790 | Shopify | Removed
- Removed deprecated column ProcessingMethod from the Orders table (REST schema).
|
| 01/18/2024 | 8783 | Shopify | Changed
- Added PublishDate, IsPublished and PublicationName columns for PublicationProducts table. The column LegacyResourceId is removed.
Added
- Added MetaObjects and MetaobjectDefinitions table for the GraphQL schema.
|
| 11/29/2023 | 8733 | General | Changed
- The ROUND function doesn't accept the negative precision values anymore.
Changed
- The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 11/28/2023 | 8732 | General | Added
- Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 09/20/2023 | 8663 | Shopify | Added
- CarrierServices is new view in the GraphQL schema.
- AppFeedbacks, and ProductResourceFeedbacks are three new tables in the GraphQL schema.
- CarrierServices, ResourceFeedbacks, and ProductResourceFeedbacks are three new tables in the Rest schema.
- The following list are stored-procedures added in Rest and GraphQL schema: SendFulfillmentRequest, AcceptFulfillmentRequest, RejectFulfillmentRequest, SendCancellationRequest, AcceptCancellationRequest and RejectCancellationRequest.
|
| 08/30/2023 | 8642 | Shopify | Added
- Added Catalogs table for the GraphQL schema.
- Added Returns table for the GraphQL schema.
- Added ReturnLineItems table for the GraphQL schema.
- Added PriceLists table for the GraphQL schema.
|
| 08/29/2023 | 8641 | Python | Added
- Added support for SQLAlchemy 2.0.
|
| 08/25/2023 | 8637 | Shopify | Changed
- Changed Fulfillments.FulfillmentOrderId from pseudo-column to column.
|
| 08/22/2023 | 8634 | Shopify | Added
- Added support for API version 2023-07, the following stored procedures have been added to the GRAPHQL-2023-07 schema to reflect the new mutations: FulfillmentOrderSplit, FulfillmentOrderMerge, CompanyContactRemoveFromCompany.
|
| 08/18/2023 | 8630 | Shopify | Added
- Added AppliesOnEachItem, DiscountOnQuantity, DiscountPercentage, DiscountQuantityToBuy, DiscountAmountToBuy, ProductsToAdd, ProductsToRemove, ProductsBuysToAdd, ProductsBuysToRemove pseudo-column to the DiscountsAutomaticBxgy table.
- Added AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove, MinimumQuantity, MinimumSubtotal pseudo-column to the DiscountsAutomaticBasic table.
- Added Code, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove pseudo-column to the DiscountsCodeApp table.
- Added Code, AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove pseudo-column to the DiscountsCodeBasic table.
- Added Code, AppliesOnEachItem, DiscountOnQuantity, DiscountPercentage, DiscountQuantityToBuy, DiscountAmountToBuy, ProductsToAdd, ProductsToRemove, ProductsBuysToAdd, ProductsBuysToRemove, AddAllCustomers, CustomersToAdd, CustomersToRemove, CustomerSegmentsToAdd, CustomerSegmentsToRemove pseudo-column to the DiscountsCodeBxgy table.
|
| 08/17/2023 | 8629 | Shopify | Changed
- Changed ThemeId of Assets table to be key for the table.
|
| 08/04/2023 | 8616 | Shopify | Changed
- Changed Articles.PublishedStatus, Comments.PublishedStatus, CustomCollections.PublishedStatus, CustomCollections.ProductId, Pages.PublishedStatus, Products.PublishedStatus, SmartCollections.PublishedStatus, SmartCollections.ProductId from pseudo-columns to columns.
- Changed names of 'Image.alt', 'Image.createdAt', 'Image.height', 'Image.src', 'Image.width', 'Image.attachment', Template_suffix', 'published_status' columns in Articles table, REST schema, to 'ImageAlt', 'ImageCreatedAt', 'ImageHeight', 'ImageSrc', 'ImageWidth', 'ImageAttachment', 'TemplateSuffix', 'PublishedStatus'.
- Changed name of 'published_status' column in Comments table, REST schema, to 'PublishedStatus'.
- Changed name of 'published_status' column in Pages table, REST schema, to 'PublishedStatus'.
Removed
- Removed pseudo-column 'status' of Comments table in REST schema. Data can now be filtered server-side through 'Status' column.
|
| 07/25/2023 | 8606 | Shopify | Added
- Added TransactionItemSource pseudo-column to the OrderTransactions table.
Changed
- Changed Authorization and Currency columns of OrderTransactions table to writable.
- Changed Metafields column of Pages table to writable.
|
| 07/24/2023 | 8605 | Shopify | Added
- Added new stored procedure CalculateRefund in REST schema, used to calculate refund transactions based on line items and shipping.
Changed
- Changed Metafields column of Blogs table to writeable.
Removed
- Removed CalculateRefund pseudocolumn from Refunds table, used to access the endpoint for calculating refunds. Refunds will be calculated through the CalculateRefund stored procedure.
|
| 07/13/2023 | 8594 | Shopify | Added
- Added EnableShopifyPlus connection property, when set to true, additional columns and tables will be available in the driver. This property is only available to accounts with a ShopifyPlus membership.
|
| 07/11/2023 | 8592 | Shopify | Added
- Added Receipt column as a JSON aggregate to the OrderTransactions table.
Removed
- Removed ReceiptTestcase and ReceiptAuthorization columns from OrderTransactions table.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 06/19/2023 | 8570 | Shopify | Removed
- From the ProductVariants table (in GraphQL schema) the Title column has been removed.
Changed
- Rest schema has been modified to REST-2023-04, which represents the REST API version 2023-04.
- GraphQL schema has been modified to GraphQL-2023-04, which represents the 2023-04 version of the GraphQL API.
Added
- Added support for pushing metafields as custom field/columns for Products and ProductVariants in the GraphQL schema.
Changed
- Changed the GraphQL data model to better align with and support version 2023-04 of the API.
- The following tables are now supported in the GraphQL schema, AppSubscriptionLineItems, AppSubscriptions, Collections, Companies, CompanyLocations, Customers, DeliveryProfiles, DiscountsAutomaticApp, DiscountsAutomaticBasic, DiscountsAutomaticBxgy, DiscountsCodeApp, DiscountsCodeBasic, DiscountsCodeBxgy, DraftOrders, FulfillmentEvents, FulfillmentOrders, Fulfillments, FulfillmentServices, FulfillmentTrackingInfo, GiftCards, InventoryItems, Metafields, Orders, OrderTransactions, ProductImages, Products, ProductVariants, Publications, Refunds, ScriptTags, SellingPlanGroups, StorefrontAccessTokens, UrlRedirects.
- The following views are now supported in the GraphQL schema, Abandonment, AbandonmentProductsAddedToCart, AbandonmentProductsViewed, AppCredits, ArticleComments, Articles, AssignedFulfillmentOrders, Blogs, CollectionProducts, CompanyEvents, CustomerEvents, DeliveryProfileLocationGroupCountries, DeliveryProfileLocationGroupCountryProvinces, DeliveryProfileLocationGroups, DeliveryProfileLocationGroupZones, DeliveryProfileUnassignedLocations, DiscountEvents, DiscountsCodeFreeShipping, DraftOrderCustomAttributes, DraftOrderEvents, DraftOrderLineItemCustomAttributes, DraftOrderLineItems, DraftOrderLineItemTaxLines, DraftOrderTaxLines, InventoryItemCountryHarmonizedSystemCodes, InventoryItemInventoryLevels, Jobs, Locations, MarketingEvents, OrderCustomAttributes, OrderDiscountApplications, OrderEvents, OrderLineItemCustomAttributes, OrderLineItemDiscountAllocations, OrderLineItems, OrderNonFulfillableLineItems, OrderRisks, OrderTaxLines, Pages, ProductOptions, PublicationCollections, PublicationProducts, RefundDuties, RefundLineItems, RefundTransactionFees, RefundTransactions, SellingPlanGroupSellingPlans, Shop, ShopifyPaymentsAccount, ShopifyPaymentsAccountBalance, ShopifyPaymentsAccountBankAccounts, ShopifyPaymentsAccountDisputes, ShopifyPaymentsAccountPayouts, ShopifyPaymentsAccountPermittedVerificationDocuments, ShopifyPaymentsAccountVerifications, StaffMembers, TenderTransactions.
- Tables support certain CUD statements in the GraphQL schema, refer to the Data Model documentation.
|
| 06/09/2023 | 8560 | Shopify | Added
- Added Fulfillments and Refunds as aggregate columns in Orders table of REST schema.
|
| 05/19/2023 | 8539 | Python | Added
- Added support for Python 3.11 on Windows, Linux and Mac.
|
| 05/16/2023 | 8536 | Python | Removed
- Removed support for Python 3.7 on Windows and Linux
|
| 04/27/2023 | 8517 | Shopify | Changed
- Changed GraphQL.DraftOrders.AppliedDiscountValue data type from "float" to "double".
- Changed GraphQL.ProductVariants.Weight data type from "float" to "double".
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 03/30/2023 | 8489 | Shopify | Added
- Added PageSize property to the Rest schema, default value is 250.
|
| 03/28/2023 | 8487 | Shopify | Added
- Added UpdateQuantity stored procedure for the Rest schema, which allows the user to update InventoryQuantity column from ProductVariants table.
|
| 02/28/2023 | 8459 | Shopify | Added
- Added Collections view to the GraphQL schema.
- Added CollectionProducts view to the GraphQL schema.
- Added Jobs view to the GraphQL schema.
- Added CollectionReorder store procedure for the GraphQL schema, which allows the user to reorder a set of products within a specified collection.
|
| 01/04/2023 | 8404 | Shopify | Added
- Added FulfillmentEvents view to the GraphQL schema. The view has server-side filtering support for FulfillmentId.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 12/07/2022 | 8376 | Shopify | Added
- In Customers table (REST and GraphQL Schema) EmailMarketingState, EmailMarketingLevel and EmailMarketingUpdatedAt columns have been added.
Changed
- In PriceRules table (REST Schema) the PrerequisiteSavedSearchIds column is based on the new customer_segment_prerequisite_ids field.
Removed
- In Customers table (REST Schema) the AcceptsMarketing column has been removed.
- In Customers table (GraphQL Schema) the AcceptsMarketingUpdatedAt and HasTimelineComment columns have been removed.
|
| 11/25/2022 | 8364 | Shopify | Added
- Added Metafields view to the GraphQL schema. OwnerResource is required and only accepts "product" or "variant" as values. The view has server-side filtering support for Id and OwnerId. The GraphQL.Metafields columns Id, LegacyResourceId, Namespace, Key, Value, Type, Description, OwnerId, OwnerResource, CreatedAt and UpdatedAt correspond to the same name columns in the REST table, except for Id and LegacyResourceId. GraphQL.Metafields.Id corresponds to REST.Metafields. AdminGraphqlApiId, and GraphQL.Metafields.LegacyResourceId corresponds to REST.Metafields.Id.
- Added Products view to the GraphQL schema. GraphQL.Products supports server-side filtering for the following columns: Id, Title, ProductType, Status, Vendor, TotalInventory, HasOnlyDefautlVariant, UpdatedAt and CreatedAt.
- Added ProductVariants view to the GraphQL schema. GraphQL.ProductVariants supports server-side filtering for the following columns: Id, ProductId, Title, Barcode, Sku, Taxable, UpdatedAt, CreatedAt, InventoryQuantity and DeliveryProfileId.
- Added ProductImages and ProductOptions view to the GraphQL schema.
Changed
- Changed REST.GraphQL.Metafields.OwnerResource column to required (except when Id is specified), and limited to the following values: shop,draft_order,product,variant,page,article,order,customer,collection,blog,product_image.
|
| 11/15/2022 | 8354 | Python | Changed
- Updated embedded JRE to jre8u345-b01(Linux x64 / MacOS x64) and jre-17.0.5+8(MacOS aarch64).
|
| 11/07/2022 | 8346 | Shopify | Changed
- For the Fulfillments table in Rest the FulfillmentOrderId pseudo column is required. The value of this column can be found in the FulfillmentOrders table. Example: Insert Into OrdersItems#Temp (ItemId) Values ('6578878840855') Insert INTO Fulfillments (FulfillmentOrderId, LocationId, LineAggregate) VALUES (315766505495, 1448280087, 'OrdersItems#Temp')
- For the Fulfillments table in Rest, only the tracking information (TrackingCompany, TrackingNumbers, TrackingUrls) is updatable.
- Changed how a Fulfillment is canceled. To cancel, the Status of the Fulfillment should be updated to cancel.
- In the MetaField the new `type` field is being used to determine the data type.
Removed
- HasNote and OrdersCount columns from the Customers table in GraphQL.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 08/29/2022 | 8276 | Shopify | Added
- Added INSERT support for MetaFields and dynamic tables (Products, ProductVariants).
Changed
- Changed how custom field names are handled. Custom fields will be pushed as either 'key' or 'namespace_key' depending on duplicates.
|
| 08/03/2022 | 8250 | Shopify | Removed
- Removed the deprecated Basic authentication. These were deprecated by Shopify in January 2022.
- The AppId and Password connection properties have been removed.
|
| 07/21/2022 | 8237 | Shopify | Added
- Added Token as an authentication scheme to be used with custom apps.
|
| 06/13/2022 | 8199 | Shopify | Deprecated
- Deprecated the RowScanDepth property.
|
| 05/19/2022 | 8174 | Shopify | Added
- Added support for the GiftCards and Users tables.
|
| 05/18/2022 | 8173 | Python | Added
- Added support for Python 3.10 on Windows, Linux, and Mac
- Added support for Python 3.9 on Mac
- Added support for Mac M1
Removed
- Removed support for Python 3.6 on Windows and Linux
|
| 05/05/2022 | 8160 | Shopify | Added
- Added support for GraphQL Bulk operations.
- Added the UseBulkApi and BulkPageSize connection properties.
|
| 04/25/2022 | 8150 | Shopify | Added
- Added the AuthScheme connection property with the options of Basic and OAuth.
|
| 04/15/2022 | 8140 | Shopify | Changed
- Querying data from 'OrderTransactions' or 'DiscountCode' with UpdatedAt filter will push the filter to the parent table, respectively 'Orders' and 'PriceRule'.
|
| 03/04/2022 | 8098 | Shopify | Changed
- Added the view ShippingItemDiscountAllocations.
|
| 02/28/2022 | 8094 | Shopify | Changed
- Added write support for the Metafields table.
|
| 02/02/2022 | 8068 | Shopify | Changed
- Changed the datatype for the ShippingZones.ProfileId and ShippingZones.LocationGroupId columns from long to string as they were marked with the incorrect data type.
|
| 12/08/2021 | 8012 | Shopify | Added
- The following columns were added to the Orders Table: TotalShippingPriceSetShopMoneyAmount and TotalShippingPriceSetShopMoneyCurrencyCode.
- Added the Metafields view.
- Added the column OrderUpdatedAt to tables OrderItemDiscountAllocations and OrderItemProperties.
- Added support for delta replication for columns OrderUpdatedAt, ProductUpdatedAt and CustomerUpdatedAt.
|
| 11/09/2021 | 7983 | Shopify | Added
- The following columns were added to the FullfillmentOrders Table: FullfillAt, Fullfillmentholds, InternationalDuties.
- The following columns were added to the Orders Table: PaymentTermsAmount, PaymentTermsCurrency, PaymentTermsPaymentTermsName, PaymentTermsPaymentTermsType, PaymentTermsDueInDays, PaymentTermsPaymentSchedules.
- The following columns were added to the OrderTransactions Table: PaymentsRefundsAttributesStatus, PaymentsRefundsAttributesAcquirerReferenceNumber.
- Added the ChannelLiable column to the TaxItems table.
|
| 10/29/2021 | 7972 | Shopify | Changed
- Updated the api version to 2021-10.
Removed
- Removed the ForceSSL field from Shop table.
|
| 09/13/2021 | 7926 | Shopify | Changed
- Updated the primary key data type from String to Long.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 07/23/2021 | 7874 | General | Changed
- Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
- As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 06/26/2021 | 7847 | Shopify | Added
- Added the AbandonedCheckoutsItems View.
|
| 06/25/2021 | 7846 | Shopify | Added
- Added the Articles, Assets, Blogs, Comments, Pages, Redirects, ScriptTags and Themes tables.
- Added the ApproveComment, ChangeSpamStatus, and RestoreComment stored procedures.
|
| 06/10/2021 | 7831 | Shopify | Added
- Added the Status column to the Products table.
Changed
- Updated the API Version to 2021-04.
|
| 04/25/2021 | 7785 | General | Added
- Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
|
| 04/23/2021 | 7783 | General | Changed
- Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 04/16/2021 | 7776 | General | Added
- Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 04/16/2021 | 7776 | General | Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
Changed
- Updated index naming convention to avoid duplicates.
|
| 04/16/2021 | 7776 | General | Changed
- Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
|
| 03/10/2021 | 7739 | Shopify | Added
- Added the ApplicationCharges, ApplicationCredit, RecurringApplicationCharges and UsageCharges tables.
|