将Mysql转换为Sequelize ORM

Question

如何将此sql转换为序列化ORM？

SELECT * 
FROM `verses`
WHERE (surah_id, verse_latin_number) >= (112, 2) 
AND (surah_id, verse_latin_number) <= (114, 3);

Answer 1

是"surah_id"；以及"；verse_latin_number"；表的2列"；诗句"？

如果是：

const db = require('...mydatabase.js')
const { Op } = require('sequelize')
db.Verses.findAll({
where: {
[Op.and]: [
{ surah_id: {[Op.gte]:112} },
{ surah_id: {[Op.lte]:114} },
{ verse_latin_number: {[Op.gte]:2} },
{ verse_latin_number: {[Op.gte]:3} }
]
})