Hi, I'm building a graph that reads from a remote database, does a simple transform, and loads the information into my local database. I need Clover to attempt an update of my existing data and, if no rows are found to update, insert a new row. I can currently update properly, but I don't know how to tell Clover to perform an insert if no rows are updated (the update operation "succeeds" even if no rows are updated, so I can't use error handling).
I couldn't find a cookbook recipe for this "upsert." Is there a way to try the update first and then do the insert?