[12.0.191 Pro] - Issues with auto-commenting auto-generated

[12.0.191 Pro] - Issues with auto-commenting auto-generated

The auto-generated/identity columns are usually the first column in a table (or very near the top) hence generating something like this below is not an issue:

	Code:
	INSERT INTO "stage"."usage_end" ( -- "h_id" -- this column value is auto-generated "external_id", "name", "code", )

It doesn't even matter when it's somewhere in the middle:

	Code:
	INSERT INTO "stage"."usage_end" ( "external_id", -- "h_id" -- this column value is auto-generated "name", "code", )

However, having them as the last column

	Code:
	INSERT INTO "stage"."usage_end" ( "external_id", "name", "code", -- "h_id" -- this column value is auto-generated )

causes SA to generate invalid code.

I know this might be considered as an edge case, and I don't really expect it to be fixed in the foreseeable future (or at all), I'm just putting it here for you to be aware of it (in case you weren't already).

Thank you. This is an issue with the internal function which applies its logic to a single column, before adding column specific line to the code, if the value is auto-generated, prefix it with -- comments. I'm submitting it as a bug, but I'm afraid that fixing it wouldn't be a trivial quick thing.

If you have your hands full with other/more important things, I'd say don't bother with it (unless a constant stream of developers keeps banging on the door demanding a fix). Most users will likely never run into this.