Return a custom dataset from select

[sagr4019]

Hey,
is it possible to return a custom dataset from a select
like in this example:
https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_groupby1
I can not find anything in the docs about that

[vmihailenco]

See https://bun.uptrace.dev/playground/

db.NewSelect().
	ColumnExpr("Shippers.ShipperName").
	ColumnExpr("COUNT(Orders.OrderID) AS NumberOfOrders").
	TableExpr("Orders").
	Join("LEFT JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID").
	GroupExpr("ShipperName")

[sagr4019]

Thank you! Is there a link to this playground page in the documentation? It's a really good starting point to understand buns semantic

[vmihailenco]

I will add the link back.