I agree with you here as I would like to do the row constructor in case of mysql server instead of correlated subqueries.