Add support for `where` in associations

[Zurga]

These are currently not supported and can lead to duplicated rows.

[Zurga]

Fragments will not be supported in the same form, but will probably require a custom function.