QBResult

query.result.distinct = true

/** @type {QBSelect<db:/example_data/person>} */
	var query = databaseManager.createSelect('db:/example_data/person')
	query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))
	foundset.loadRecords(query)

/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')
	
 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query
		.or 
			.add(query.columns.order_id.not.isin([1, 2, 3]))
			
			.add(query.exists(
					subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
			))
		)
		
	foundset.loadRecords(query)

query.result.add(query.columns.label_text.max)

query.result.add(query.columns.item_count.max, 'maximum_items')

query.result.add(query.columns.custname)

query.result.add(query.columns.custname, 'customer_name')

query.result.add(query.columns.custname.upper())

query.result.add(query.columns.custname.upper(), 'customer_name')

query.result.addPk()

query.result.addValue(100)

query.result.addValue(100, 'myvalue')

query.result.clear()