Some SATA SSDs have a cached mode where data gets put into normal RAM first, and then copied onto the SSD, but it's not really useful other than getting overinflated benchmarking numbers (things get messy if your system loses power before the data can transfer from RAM to the disk). Samsung calls it RAPID, the Crucial name is Momentum Cache
https://www.scorptec.com.au/product/hard-drives-&-ssds/solid...
That's a SATA drive rated for 5,600 TBW, and it's "maximum" rated write speed is 540MB/s.
To work out how long the drive should last at that maximum speed, let's do:
540MB/s * 60 (seconds) * 60 (minutes) = 1,9444,000 MB per hour
We take the rated endurance of 5,600 TBW, and divide it by the above 2 TB/h, giving us "2,800" hours worth of write endurance.
At 24 hours in a day, that's 116 2/3 days worth of endurance at the maximum write speed the whole time.
Anyway, if the project in mind is going to run for less than ~120 days, it should be ok. Any other hardware/software issues aside that is.