QB tries to automatically figure out what ColdFusion SQL type to use for updates and inserts based on the actual value that is passed in for each column. Although that works for most of the cases, I ran into an issue where my value type was being wrongly inferred so I needed to figure out how to override it.

Making use of the preQBExecute() and postQBExecute() QB interception points I can capture the actual SQL getting generated and running against my database.