You need to study "<u>[Name Of The Folder Holding Temporary Files](https://sqlite.org/c3ref/temp_directory.html)</u>", carefully. In my opinion, if you are going to takeover that decision, you may as well do it decisively rather than indirectly via an environment variable. Please note that these comments do not constitute any condonation contravening the cautions mentioned in the above-linked doc page.