7 replies

SELECT 'value'

RiftLurker · 2024-07-17T08:46:00.908Z

Is there some way to model `SELECT 'value'` without a table in drizzle? Specifically I'm trying to do something like ```sql SELECT value FROM user_config WHERE user_id = 1 UNION ALL SELECT 'fallback' ``` but couldn't find a way to create the SELECT for unionAll ```ts const query = db.select({ value: UserConfig.value, }) .from(UserConfig) .where(eq(UserConfig.userId, 1)) query.unionAll( // How to create select here? ) ``` I can of course create it as a raw query and handle the types myself ```ts sql`${query} UNION ALL SELECT ${'fallback'}` ```

Is there some way to model

SELECT 'value'

SELECT 'value'

without a table in drizzle?

Specifically I'm trying to do something like

    SELECT
        value
    FROM
        user_config
    WHERE
        user_id = 1
    UNION ALL
        SELECT
            'fallback'

    SELECT
        value
    FROM
        user_config
    WHERE
        user_id = 1
    UNION ALL
        SELECT
            'fallback'

but couldn't find a way to create the SELECT for unionAll

const query = db.select({
    value: UserConfig.value,
  })
  .from(UserConfig)
  .where(eq(UserConfig.userId, 1))

query.unionAll(
// How to create select here?
)

const query = db.select({
    value: UserConfig.value,
  })
  .from(UserConfig)
  .where(eq(UserConfig.userId, 1))

query.unionAll(
// How to create select here?
)

I can of course create it as a raw query and handle the types myself

sql`${query} UNION ALL SELECT ${'fallback'}`

sql`${query} UNION ALL SELECT ${'fallback'}`

Drizzle Team•2y ago•

7 replies

RiftLurker

SELECT 'value'

Is there some way to model

SELECT 'value'

SELECT 'value'

without a table in drizzle?

Specifically I'm trying to do something like

    SELECT
        value
    FROM
        user_config
    WHERE
        user_id = 1
    UNION ALL
        SELECT
            'fallback'

    SELECT
        value
    FROM
        user_config
    WHERE
        user_id = 1
    UNION ALL
        SELECT
            'fallback'

but couldn't find a way to create the SELECT for unionAll

const query = db.select({
    value: UserConfig.value,
  })
  .from(UserConfig)
  .where(eq(UserConfig.userId, 1))

query.unionAll(
// How to create select here?
)

const query = db.select({
    value: UserConfig.value,
  })
  .from(UserConfig)
  .where(eq(UserConfig.userId, 1))

query.unionAll(
// How to create select here?
)

I can of course create it as a raw query and handle the types myself

sql`${query} UNION ALL SELECT ${'fallback'}`

sql`${query} UNION ALL SELECT ${'fallback'}`

SELECT 'value'

Similar Threads

SELECT 'value'

Similar Threads

Similar Threads

Similar Threads