Gorm How to use Limit,Offset,Order using Raw SQL ?

Describe the feature

How can use this query: db.Raw("SELECT * FROM users").Limit(10).Offset(1).Scan(&users)

Thanks you.

Motivation

Related Issues

Comment From: github-actions[bot]

This issue has been automatically marked as stale as it missing playground pull request link, checkout https://github.com/go-gorm/playground for details, it will be closed in 2 days if no further activity occurs.

Comment From: jinzhu

GORM won't change raw SQL

Comment From: nmccready

GORM won't change raw SQL

Why the heck not? This worked great in older gorm? If this will never work than Limit or Offset should at the very least throw Errors or add errors to the chain.