Pg CRUD for joined tables

I'm looking for FOSS PostgreSQL CRUD software, preferably
Perl-compatible, which will enable me to design input forms which can
handle input to tables which reference other tables by foreign key.
Most CRUD applications I have seen so far only deal with direct, form
field to table field input but I want to build forms which have the
same fields as a VIEW derived from multiple table joins. In other
words, I want the CRUD to handle the the joins.

Any suggestions?

Not for Perl, but Python: SQLalchemy. An ORM that allows you to have
(nearly) arbitrarily complex mappings between your object model and the
database tables. GUI frameworks that use SQlalchemy are: Sqlkit,
Pypapi, Camelot, Qtalchemy.

Sincerely,

Wolfgang