SQL Dump : invisible columns not exported

[cedx]

Preconditions

• HeidiSQL version: 12.6.0.6765
• Database type and version: MariaDB 10.11.6
• OS: Windows 11 (23H2)

Describe the bug

When a database/table is exported to SQL, columns marked as invisible are not included in the SQL dump.
I expect that the resulting dump to be the same as the one produced by the equivalent mysqldump command (which obviously includes invisible columns).

To Reproduce

1. Go to Tools > Export database as SQL
2. Select a database or table containing invisible columns.
3. Select an SQL output.
4. Click on Export.

Screenshots or Crash reports

The dump generated by HeidiSQL:

DROP TABLE IF EXISTS `picture`;
CREATE TABLE IF NOT EXISTS `picture` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp(),
  `ipAddress` inet6 NOT NULL,
  `format` enum('avif','gif','jpeg','png','webp') NOT NULL DEFAULT 'webp',
  `source` mediumblob NOT NULL INVISIBLE DEFAULT _binary'RIFF$x00x00x00WEBPVP8 x18x00x00x000x01x00x9Dx01*x01x00x01x00x0FxC0xFE%xA4x00x03px00xFExE5jx00x00',
  `thumbnail` blob NOT NULL INVISIBLE DEFAULT _binary'RIFF$x00x00x00WEBPVP8 x18x00x00x000x01x00x9Dx01*x01x00x01x00x0FxC0xFE%xA4x00x03px00xFExE5jx00x00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `picture` (`id`, `createdAt`, `ipAddress`, `format`) VALUES
	(1, '2023-12-08 00:08:34', '::ffff:127.0.0.1', 'webp'),
	(2, '2023-12-08 00:08:41', '::ffff:127.0.0.1', 'webp'),
	(3, '2023-12-13 11:43:10', '::ffff:192.168.0.1', 'webp'),
	(4, '2023-12-13 11:47:50', '::ffff:192.168.0.2', 'jpeg');

[ansgarbecker]

Related to #872