Select & Include

Use select to project fields and include to load related records.

select()

ballerina

var rows = check db.'from(User)
    .'select({
        id: true,
        email: true,
        name: true
    })
    .take(20)
    .findMany();

ballerina

var users = check db.'from(User)
    .include({
        posts: true
    })
    .findMany();

ballerina

var rows = check db.'from(User)
    .'where({status: {equals: "ACTIVE"}})
    .'select({id: true, email: true})
    .findMany();

Continue with Raw SQL.