JSON Sugars

Linked QL supports a few JSON-like syntaxes for modelling structure.

Example 1:

// Object and array sugars
const result = await client.query(
    `SELECT
        name,
        { email, phone AS mobile } AS contact1,
        [ email, phone ] AS contact2
    FROM users`
);
console.log(result);

Console

[
    {
        name: 'John Doe',
        contact1: {
            email: '[email protected]',
            mobile: '(555) 123-4567'
        },
        contact2: [ '[email protected]', '(555) 123-4567' ]
    },
    {
        name: 'Alice Blue',
        contact1: {
            email: '[email protected]',
            mobile: '(888) 123-4567'
        },
        contact2: [ '[email protected]', '(888) 123-4567' ]
    }
]

Example 2:

// Aggregation sugar
const result = await client.query(
    `SELECT
        email[] as emails
    FROM users`
);
console.log(result);

Console

[
    {
        emails: ['[email protected]', '[email protected]']
    }
]