sql,log: productionize the event logging

[jseldess]

PR: cockroachdb/cockroach#57737

• The payload fields for certain event types in system.eventlog have been changed and/or renamed. Note that the payloads in system.eventlog were an undocumented, reserved feature so no guarantee was made about cross-version compatibility to this point. The list of changes includes (but is not limited to):
  • TargetID has been renamed to NodeID for node_join.
  • TargetID has been renamed to TargetNodeID for node_decommissioning / node_decommissioned / node_recommissioned.
  • NewDatabaseName has been renamed to NewDatabaseParent for convert_to_schema.
  • grant_privilege and revoke_privilege have been removed; they are replaced by change_database_privilege, change_schema_privilege, change_type_privilege, and change_table_privilege. Each event only reports change for one user/role, so the Grantees field was renamed to Grantee.
  • Each drop_role event now pertains to a single user/role. [#57737][#57737]

[taroface]

Closed by #10273.