Issue with SQL Package: SELECT with LIMIT and OFFSET Not Working Correctly

I was wondering if anyone else is using the SQL package, because the SELECT with

LIMIT

LIMIT

(and

OFFSET

OFFSET

) query isn't working correctly and I want to make sure it's my problem. I searched discord to see if there's an issue about it, but I didn't find it. Here's the one I raised on GitHub. https://github.com/Effect-TS/effect/issues/5005#issuecomment-3194346256

Issue with SQL Package: SELECT with LIMIT and OFFSET Not Working Correctly - Effect Community