pagehelper-org/Mybatis-PageHelper ? reverse-engineered prompt
Reverse engineered prompt
Build me a MyBatis pagination plugin that makes it really easy to add paging to existing queries without rewriting a lot of SQL. It should work for simple and more complex single table and multi table queries, and automatically handle physical pagination for common databases like MySQL, PostgreSQL, Oracle, SQL Server, DB2, SQLite, and others if possible. I want it to plug into MyBatis cleanly as an interceptor, with a simple way to configure it in Maven and XML, and clear support for using it in Spring and Spring Boot too.
Please include sensible defaults, a way to detect the database automatically from the datasource when you can, and a fallback for custom dialect aliases if someone is using a database that is not built in. Make sure it is easy to understand from the README how to use it, and keep the implementation compatible with MyBatis 3.1 plus. If you need to check current docs for anything, go ahead and look them up online.
Are you gonna build this?
make sure you review the code using coderabbit