It’s easier to tell Duplicati to use a different tempdir. There’s an option by that name in Advanced options, but I’m not certain it works exactly as it says, especially with Linux.
gives me hope, and you can read the rest of the discussion there on difficulties with this. There was at least one case I found where it seemed like SQLite had set itself up before request for change was processed. Maybe prior action already had gotten it initialized…