I think in principle we could allow INSERT INTO table1 col_1 = COUNT(table2.col_6), col_2 = table2.col_4, col3 = table2.col_5 F

I think in principle we could allow INSERT INTO table1 col_1 = COUNT(table2.col_6), col_2 = table2.col_4, col3 = table2.col_5 FROM table2 INNER JOIN ...