I’m not sure about your needs, but you can try adding the @SelectProvider annotation to the mapper interface. By customizing the sql, you can process the sql differently based on the parameters. Similarly, there are @UpdateProvider, @ DeleteProvider, @InsertProvider these annotations.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
I’m not sure about your needs, but you can try adding the @SelectProvider annotation to the mapper interface. By customizing the sql, you can process the sql differently based on the parameters. Similarly, there are @UpdateProvider, @ DeleteProvider, @InsertProvider these annotations.