Timezone Trouble with DuckDB and Observable plot

[c-koster]

Hi all,

I've been having some trouble working with some timezone-aware DuckDB SQL statements. I am trying to use some timestamptz operations which exist in the DuckDB documentation but don't appear to be installed in framework.

For example, this query

SELECT date_diff('day', TIMESTAMPTZ '1992-09-30 23:59:59', TIMESTAMPTZ '1992-10-01 01:58:00')

fails but the following one works fine:

SELECT date_diff('day', TIMESTAMP '1992-09-30 23:59:59', TIMESTAMP '1992-10-01 01:58:00')

I think this means that the ICU library isn't installed and also doesn't get auto-loaded when one of these functions is called. I also tried preceding the first query with INSTALL icu; and LOAD icu; but got the following error from the install step:

Error: IO Error: Can't find the home directory at '/home/web_user'
Specify a home directory using the SET home_directory='/path/to/dir' option.

Is there any way to import non-standard modules to the Duck DB instance? I think this is related to #1070.

Thank you!