While certain columns are hidden from view, the Copy as SQL INSERTs operation fails to include those columns in the statement.
This results in a mismatch of columns when attempting to apply this INSERTs to an identical database that lives somewhere else.
The error shown is: SQL Error (1136): Column count doesn't match value count at row 1
Based on the images included with this post, you can see that if I have the column "Family" hidden from view and I perform the operation Copy as SQL INSERTs, I get:
INSERT INTO mammals VALUES (1, 'wolf');
But I had hoped there was a way to get all the columns, whether they are hidden or not:
INSERT INTO mammals VALUES (1, 'wolf', 'Canidae');
I think both scenarios are valid. I can see how creating a statement for the visible columns only is a good thing to have, but I think there should be an option that captures all columns as well, whether they are visible or not.