Dwg file reading and rendering does not create temporary files and does not use sqlite. Temporary files can be created for writing undo information. To prevent it you can try pDb->disableUndoRecording(true).
Such temporary files are created by DWF Toolkit which uses sqlite (based on file name prefix).
More information in API Reference