How to count records and group them by day, week or month?

[GP4cK]

Let's say I have an entity like:

class TodoItem {
  @Field()
  @Column({ type: 'varchar' })
  title: string

  @FilterableField()
  @Column({ type: 'timestamp' })
  createdAt: number
}

In postgres, you can use DATE_PART to extract the week, the month etc. from a date.

I'd like to create a graphql query that will return the number of TodoItem created per week, for example.
I know from the example that nestjs-query generates a TodoItemCountAggregate and TodoItemAggregateGroupBy already but if I groupBy createdAt, it will group by the timestamp in ms.

Is it possible in some way to write a query which will make use of postgres powerful DATE_PART feature?