Possibility to override more Types through __construct($config) string

[Ejsstiil]

We can change only few types for normalize() behaviour.
JSON, DATE, DATETIME
like here:

dibi/src/Dibi/Connection.php

Lines 64 to 65 in 70e940f

	Helpers::alias($config, 'result|formatDate', 'resultDate');
	Helpers::alias($config, 'result|formatDateTime', 'resultDateTime');

• Current problem

We don't have access to modify behaviour for the rest - namely for TIME and TIME_INTERVAL.

1. MariaDB's TIME column become \DateInterval which is the problem i currently have.
   This block is hit even when column native type is "TIME":
   

   dibi/src/Dibi/Result.php

   Lines 493 to 496 in 70e940f

   	} elseif ($type === Type::TIME_INTERVAL) {
   	preg_match('#^(-?)(\d+)\D(\d+)\D(\d+)\z#', $value, $m);
   	$row[$key] = new \DateInterval("PT$m[2]H$m[3]M$m[4]S");
   	$row[$key]->invert = (int) (bool) $m[1];

2. Also its not possible to call ->setFormat() or ->setType() when you using \Fluent unlike here:
   

   dibi/examples/result-set-data-types.php

   Lines 26 to 33 in 70e940f

   	// using manual hints
   	$res = $dibi->query('SELECT * FROM [customers]');
   	$res->setType('customer_id', Type::INTEGER)
   	->setType('added', Type::DATETIME)
   	->setFormat(Type::DATETIME, 'Y-m-d H:i:s');

• Explain your intentions.

1. As title says - to able these to configure (or suppress) via constructor $config string.
   Add TIME and TIME_INTERVAL to configurable parameters and allow to set them to 's', // as 'string' to keep column as is.

	'lazy'     => '1',
	'charset'  => 'utf8',
	'result'   => ['formatDate' => 'Y-m-d', 'formatDateTime' => 'Y-m-d H:i:s', 'formatJson' => 'string', 
'formatTime' => 'string', 'formatTimeInterval' => 'string']

dibi/src/Dibi/Type.php

Lines 27 to 28 in 70e940f

	TIME = 't',
	TIME_INTERVAL = 'ti';

2. Maybe some another flag to disable normalizer() along with detectTypes() completellly

dibi/src/Dibi/Result.php

Line 435 in 70e940f

private function detectTypes(): void

and

dibi/src/Dibi/Result.php

Line 450 in 70e940f

private function normalize(array &$row): void

• It's up to you to make a strong case to convince the project's developers of the merits of this feature.
  Not in every environment such auto-re-typing to PHP's types is useful and to conform the freedom Ill suggest this change.

[Ejsstiil]

Any comment on this?

[dg]

I added options result > normalize to disable normalize, result > formatTimeInterval to affect interval format and option value 'native' to leave value as is.