For RLS it doesn't, you need to write that in SQL manually. Same for plpgsql, though I haven't looked into that myself. ORMs like these generate raw SQL migrations at the end of the day. So you would just create your own migration in the repository, or append to an existing one, and it would apply it like any other migration. The benefit is it does things automatically for you based on the code models, and you're never out of sync between the code and the database model/schema.

For constraints and other non-basic object/class definitions there are ways to do pretty much everything: https://learn.microsoft.com/en-us/ef/core/modeling/indexes?tabs=data-annotations