Result

Execut SOQL and get results.

public inherited sharing class AccountSelector implements SOQL.Selector {

    public static SOQL query {
        return SOQL.of(Account.SObjectType)
            .with(Account.Id, Account.Name);
    }
}

public with sharing class MyController {

    public static String getAccountName(Id accountId) {
        return (String) AccountSelector.query()
            .whereAre(SOQL.Filter.id().equal(accountId))
            .toField(Account.Name);
    }

    public static Account getAccountById(Id accountId) {
        return (Account) AccountSelector.query()
            .whereAre(SOQL.Filter.id().equal(accountId))
            .toObject();
    }

    public static List<Account> getAccountsByIds(List<Id> accountIds) {
        return AccountSelector.query()
            .whereAre(SOQL.Filter.id().isIn(accountIds))
            .toList();
    }

    public static List<AggregateResult> getUniqueAccountNameAmount() {
        return AccountSelector.query().count(Account.Name, 'names').toAggregated();
    }

    public static Integer countAccounts() {
        return AccountSelector.query().count().toInteger();
    }

    public static Map<Id, SObject> getAccountMap() {
        return AccountSelector.query().toMap();
    }

    public static Database.QueryLocator getAccountQueryLocator() {
        return AccountSelector.query().toQueryLocator();
    }
}