Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Should something like this work?
```ts
await supabase
  .from('posts')
  .update({ valid_until: `now() + interval '30 day'` })
  .eq('id', postId);
```
`valid_until` is of type `timestamp with time zone`

Edit: It would appear not... What's the best way to achieve this?
```json
{
  "hint": null,
  "message": "invalid input syntax for type timestamp with time zone: \"now() + interval '30 day'\"",
  "code": "22007",
  "details": null
}
```

I would suggest you either do this in JavaScript using `new Date` function or make the valid_until happen in a stored procedure or a function.

I opted for a psql function, thanks <@!107176742342402048>  🙂