String concatenation syntax - Drizzle Team

Drizzle Team•5mo ago

String concatenation syntax

Is there a better a way to concatenate strings in the select of a query? I'm currently doing this:

    const bucketUrl = `${env.MINIO_ENDPOINT}/${env.MINIO_BUCKET_NAME}/${RESOURCE_PREFIX}/`;

    const query = db
      .select({
        ...getTableColumns(resources),
        path: sql<string>`concat(${bucketUrl}::text, ${resources.id}, '/', ${resources.path})`,
      })
      .from(resources)

    const bucketUrl = `${env.MINIO_ENDPOINT}/${env.MINIO_BUCKET_NAME}/${RESOURCE_PREFIX}/`;

    const query = db
      .select({
        ...getTableColumns(resources),
        path: sql<string>`concat(${bucketUrl}::text, ${resources.id}, '/', ${resources.path})`,
      })
      .from(resources)