Astro DB - Many-to-many relationship

[piotrkulpinski]

Hi,
I'm trying out Astro DB and want to create simple database for my blog.
I want my posts to have categories, so I'd need a many-to-many relationship between them.

Here's what I have:

const Post = defineTable({
  columns: {
    id: column.number({ primaryKey: true, unique: true }),
    name: column.text(),
  },
});

const Category = defineTable({
  columns: {
    id: column.number({ primaryKey: true, unique: true }),
    name: column.text(),
  },
});

const PostCategory = defineTable({
  columns: {
    postId: column.number({ references: () => Post.columns.id }),
    categoryId: column.number({ references: () => Category.columns.id }),
  },
});

With such db design, I need to use inner joins with every query I do, right?
Is there any simpler way to do that? I'd love to be able to define the relations on the main tables and have Astro DB create the relation table for me automatically.

Thanks!