#QueryExpression
LightNews LightNews
pointfree.co
It's possible to cook up a micro library of query helpers for your app, and then piece them together to form more complex queries.

Here we have query fragments for selecting past due reminders, scheduled reminders, reminders due today, and for aggregating tag titles into an array of strings!
Screenshot of code showing how to define SQL query helpers. The code reads as follows: extension Reminder.TableColumns { var isPastDue: some QueryExpression<Bool> { !isCompleted && (dueDate ?? Date.distantFuture) < Date() } var isScheduled: some QueryExpression<Bool> { dueDate.isNot(nil) } var isToday: some QueryExpression<Bool> { #sql("date(\(dueDate)) = date()") } } extension Tag.TableColumns { var jsonTitles: some QueryExpression<[String].JSONRepresentation> { title.jsonGroupArray(filter: id.isNot(nil)) } }
June 17, 2025 at 3:49 PM
pointfree.co
Swift’s parameter packs is a powerful tool that we can leverage for selecting any number of columns in our SQL query builder. We can even support complex aggregate functions!

Watch this week's episode to learn how: www.pointfree.co/episodes/ep3...
The following code snippet: extension Table { static func select<each ResultColumn: QueryExpression>( _ columns: (Columns) -> (repeat each ResultColumn) ) -> Select { // ... } } Reminder.select(\.title) Reminder.select { ($0.title, $0.isCompleted) } Reminder.select { ($0.id.count(), $0.priority.avg(), $0.title.groupConcat(", ")) }
March 20, 2025 at 6:49 PM
jonasrapp.bsky.social
It may also be more efficient (from a database perspective) to include the link entities in the filters...

A relatively new feature that is available in FetchXML.
Try it, test it, compare it!

It is not supported by QueryExpression, though; use FetchExpression instead.
January 15, 2025 at 9:23 AM
edwardsdna.bsky.social
When Entity.Id Is Guid.Empty with QueryExpression.Distinct = True (Dataverse): While optimising the performance of a Dataverse plugin, we noticed a QueryExpression using ColumnSet(true). The business logic only required a few… @nishantranaCRM #Dataverse #QueryExpression #PluginDevelopment
When Entity.Id Is Guid.Empty with QueryExpression.Distinct = True (Dataverse)
While optimising the performance of a Dataverse plugin, we noticed a QueryExpression using ColumnSet(true). The business logic only required a few attributes, so replacing ColumnSet(true) with a minimal ColumnSet looked like an easy performance improvement. The query also used Distinct = true, which we left unchanged because it had always been there and everything was … Continue reading "When Entity.Id Is Guid.Empty with QueryExpression.Distinct = True (Dataverse)"
dlvr.it
September 16, 2026 at 7:04 PM
pointfree.co
We received many reactions to code like this a few months ago when we previewed our SQL building library.

We are leveraging the power of Swift parameter packs to select any number of expressions from any number of joined tables. Once you understand the syntax it is quite easy!
Screenshot of code showing a method that uses parameter packs. The code reads as follows: func select<each ResultColumn: QueryExpression>( _ columns: (From.Columns, repeat (each Join).Columns) -> (repeat each ResultColumn) ) -> Select { let columns = columns(From.columns, repeat (each Join).columns) var columnStrings: [String] = [] for column in repeat each columns { columnStrings.append(column.queryString) } return Select( columns: self.columns + columnStrings, groups: groups, havings: havings, joins: joins, orders: orders, wheres: wheres ) }
April 18, 2025 at 3:15 PM
pointfree.co
This week we introduce type-safety to our SQL builder library! By leveraging primary associated types we get a lightweight syntax to describe exactly what type of expression is valid at compile time.

Watch our video to see how it's done: www.pointfree.co/episodes/ep3...
The following code snippet: // 1️⃣ Introduce a primary associated type that pins a // given fragment of SQL with a type. // // E.g., "priority = 3" is 'some QueryExpression<Bool>' protocol QueryExpression<QueryValue> { associatedtype QueryValue var queryString: String { get } } extension Select { // 2️⃣ Leverage this type in our builder API. // // For example, we can require that the "WHERE" clause // returns a Boolean expression: func `where`( _ predicate: (From.Columns) -> some QueryExpression<Bool> ) -> Select { // ... } }
April 2, 2025 at 4:09 PM
inogic.bsky.social
Using Aggregate Functions with QueryExpression in Dynamics 365

buff.ly/PIqMAhP

#QueryExpression #Dynamics365 #MSDyn365
Using Aggregate Functions with QueryExpression in Dynamics 365 - Microsoft Dynamics 365 CRM Tips and Tricks
Introduction In Microsoft Dataverse (Power Apps), there is often a need to retrieve summarized or aggregated data, such as counts, averages, sums, minimums, or maximums, rather than retrieving every…
buff.ly
July 9, 2025 at 10:30 PM
inogic.bsky.social
Using Aggregate Functions with QueryExpression in Dynamics 365

buff.ly/PIqMAhP

#QueryExpression #Dynamics365 #MSDyn365
Using Aggregate Functions with QueryExpression in Dynamics 365 - Microsoft Dynamics 365 CRM Tips and Tricks
Introduction In Microsoft Dataverse (Power Apps), there is often a need to retrieve summarized or aggregated data, such as counts, averages, sums, minimums, or maximums, rather than retrieving every…
buff.ly
July 5, 2025 at 2:30 PM
inogic.bsky.social
Using Aggregate Functions with QueryExpression in Dynamics 365

buff.ly/d7CrHsE

#QueryExpression #Dynamics365 #MSDyn365
Using Aggregate Functions with QueryExpression in Dynamics 365 - Microsoft Dynamics 365 CRM Tips and Tricks
Introduction In Microsoft Dataverse (Power Apps), there is often a need to retrieve summarized or aggregated data, such as counts, averages, sums, minimums, or maximums, rather than retrieving every…
buff.ly
June 23, 2025 at 2:30 PM
365community.online
** NEW BLOG** Using Aggregate Functions with QueryExpression in Dynamics 365 By inogicmsdyn365dataverseapps

Introduction
In Microsoft Dataverse (Power Apps), ...

https://365community.online/using-aggregate-functions-with-queryexpression-in-dynamics-365

#365CommunityOnline #MircosoftCommunity
Using Aggregate Functions with QueryExpression in Dynamics 365
June 20, 2025 at 8:50 AM
365community.online
** NEW BLOG** Using Aggregate Functions with QueryExpression in Dynamics 365 By inogicmsdyn365dataverseapps

Introduction
In Microsoft Dataverse (Power Apps), ...

https://365community.online/using-aggregate-functions-with-queryexpression-in-dynamics-365

#365CommunityOnline #MircosoftCommunity
June 20, 2025 at 8:50 AM