DT
Drizzle Team•3mo ago
Kneemund

reusing placeholders

Is it possible to reuse placeholders with the same value instead of passing them to the driver every time they're referenced? Simply giving them the same name doesn't seem work. Drizzle creates a separate SQL parameter for each placeholder regardless. Example This is what Query#params looks like after referencing two placeholders multiple times. 
[
  Placeholder {
    name: "warningTimestamp",
    getSQL: [Function: getSQL],
  }, Placeholder {
    name: "warningTimestamp",
    getSQL: [Function: getSQL],
  }, Placeholder {
    name: "userId",
    getSQL: [Function: getSQL],
  }, Placeholder {
    name: "warningTimestamp",
    getSQL: [Function: getSQL],
  },
  ...
]
[
  Placeholder {
    name: "warningTimestamp",
    getSQL: [Function: getSQL],
  }, Placeholder {
    name: "warningTimestamp",
    getSQL: [Function: getSQL],
  }, Placeholder {
    name: "userId",
    getSQL: [Function: getSQL],
  }, Placeholder {
    name: "warningTimestamp",
    getSQL: [Function: getSQL],
  },
  ...
]
1 Reply
zoriya
zoriya•3w ago
necroposting but did you find a workarround or reported the issue on gh?

Did you find this page helpful?