Using Model's CRUD methods in advanced queries

Hi all,
I have created 3 tables in my database.

Code:

Products (ID, name)
Categories (ID, name)
Products_Categories (productID, categoryID)

This last table is used to link one or more categories to one or more products.
Can I use CRUD methods available in CI 4 to get, for example, all products in a given category?
Thanks for your help.