Infer type in COALESCE when using AS

[vanniktech]

Description

Somewhat related issue: #3416

I have two tables:

import kotlin.time.Duration;

CREATE TABLE directory (
  id TEXT NOT NULL PRIMARY KEY,
  backgroundRefreshInterval INTEGER AS Duration
)

CREATE TABLE channel (
  id TEXT NOT NULL PRIMARY KEY,
  directoryId TEXT,
  backgroundRefreshInterval INTEGER AS Duration,
  FOREIGN KEY (directoryId) REFERENCES directory(id)
)

then I have my custom query:

backgroundRefreshIntervals:
SELECT COALESCE(directory.backgroundRefreshInterval, channel.backgroundRefreshInterval) AS backgroundRefreshInterval
  FROM channel
  LEFT JOIN directory
    ON channel.directoryId = directory.id
;

This is the generated class:

public data class BackgroundRefreshIntervals(
  public val backgroundRefreshInterval: Long?,
)

Although I'd really like to have:

-  public val backgroundRefreshInterval: Long?,
+  public val backgroundRefreshInterval: Duration?,

[vanniktech]

Argh. This is a duplicate of #3572