Drizzle generates PG statement with parentheses on order by clause

Hello!

I'm trying to execute a simple query with Drizzle, but it generates an invalid SQL statement.

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

This is the generated SQL:

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

(error: syntax error at or near "desc" at character 113)

(error: syntax error at or near "desc" at character 113)

(error: syntax error at or near "desc" at character 113)

(error: syntax error at or near "desc" at character 113)

Looks like a parentheses is added on the order by clause. Am I doing something wrong?

Drizzle generates PG statement with parentheses on order by clause

Similar Threads

Similar Threads

Similar Threads