Writing more than one layer to a GeoPackage file

[HanOostdijk]

I did not succeed in writing two layers to a GeoPackage with DuckDB CLI.
My version of DuckDB CLI is v0.9.2 3c695d7ba9 (on Windows 11)
Writing one layer goes well when I use e.g. the following script (as stdin) :

LOAD spatial ;
CREATE TABLE example1 AS
SELECT 'abcde' AS alpha, 31415 AS number,
ST_Transform(ST_GeomFromText('POINT(-100 40)'),'EPSG:4326', 'EPSG:5070', true) as geom;
COPY example1 TO 'file1.gpkg' WITH (FORMAT GDAL, DRIVER 'GPKG' ,
LAYER_NAME 'layer1x', SRS 'EPSG:5070');
.exit

When I add a second COPY statement with a different layer name the layer is written to file.gpkg.tmp (notice tmp) and I see the message Error: near line xxx: IO Error: Could not move file: The process cannot access the file because it is being used by another process.
The same happens when I try to add the second layer with a second script.

So questions:

• is it possible to write more than one layer to a GeoPackage with a DuckDB CLI script?
• if it is possible: how to adapt the script?
• if it is not possible, is this somewhere documented?

Thanks in advance!