Yes, NORMA can map any relational view generated from an ORM schema to SQL. For example, see NORMA Lab1 (accessible from the ORM Foundation website or my www.orm.net website). For more details on the SQL mapping procedure, see Appendix A (pp. 157-164) of Halpin, T. 2015, Object-Role Modeling Fundamentals,
Technics Publications, New Jersey.