feat: FindUnique by unique attribute

[jjranalli]

as of v.0.6.22, findUnique only accepts id as parameter. it would be more useful if any unique attribute could be used to filter. this in turn would require adding support for marking columns as unique in the schema.

relatedly, I think a findFirst would also be nice addition. my current workaround is the following

const { items } = await db.Slicer.findMany({
    where: {
      address: slicerAddress
    },
    limit: 1
})

[typedarray]

This will be largely addressed in the upcoming 0.7 release, which adds support for arbitrary SQL select statements within indexing functions and a high-level findFirst API.

However, we don't plan to support SQL unique constraints (other than the primary key), so this won't be 100% solved.

[typedarray]

We just released 0.7 - here's the new store API. No support for non-PK unique constraints, but you can now use the raw SQL API to achieve this:

const slicer = await db.sql.query.slicers.findFirst({
  where: (slicers, { eq }) => eq(slicers.address, slicerAddress),
});

Also, curious what your slicers column types look like - a composite primary key might help here.

[jjranalli]

awesome, I'll look into it! this is the current schema