invalid input syntax for type timestamp with time zone: "STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')"

[EricBLivingston]

• pgloader --version

  pgloader version "3.6.3~devel"
  compiled with SBCL 2.1.11.debian
  

• did you test a fresh compile from the source tree?

  No, I did sudo apt install pgloader in wsl

• did you search for other similar issues?

• how can I reproduce the bug?

LOAD DATABASE
FROM sqlite://database.sqlite
INTO postgresql://user@192.168.1.25:5432/db

WITH include drop,
     create tables,
     create indexes,
     reset sequences

;

• pgloader output you obtain

2024-12-09T15:29:55.010000Z LOG pgloader version "3.6.3~devel"
2024-12-09T15:29:55.010000Z LOG Parsing commands from file #P"pgloader.conf"
2024-12-09T15:29:55.160009Z LOG Migrating from #<SQLITE-CONNECTION sqlite://database.sqlite {1007FB0483}>
2024-12-09T15:29:55.160009Z LOG Migrating into #<PGSQL-CONNECTION pgsql://user@192.168.1.25:5432/db {1007FB0FB3}>
2024-12-09T15:29:55.620034Z ERROR Database error 22007: invalid input syntax for type timestamp with time zone: "STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')"
QUERY: CREATE TABLE role
(
id bigserial,
name text,
scope text,
createdat timestamptz default 'STRFTIME(''%Y-%m-%d %H:%M:%f'', ''NOW'')',
updatedat timestamptz default 'STRFTIME(''%Y-%m-%d %H:%M:%f'', ''NOW'')'
);
2024-12-09T15:29:55.630035Z FATAL Failed to create the schema, see above.
2024-12-09T15:29:55.630035Z LOG report summary reset
table name errors rows bytes total time

---

        fetch          0          0                     0.000s

fetch meta data 0 116 0.310s
Create Schemas 0 0 0.000s
Create SQL Types 0 0 0.010s
Create tables 0 0 0.000s

---

---