# 关于数据对象模型的疑问

**URL:** <https://forum.jit.pro/t/topic/357>\
**Category:** How To\
**Created:** [October 10, 2025, 3:43am UTC](https://forum.jit.pro/t/topic/357 "2025-10-10T03:43:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hww](https://avatars.discourse-cdn.com/v4/letter/h/e56c9b/32.png) [@hww](https://forum.jit.pro/u/hww)\
**Post date:** [October 10, 2025, 3:43am UTC](https://forum.jit.pro/t/topic/357/1 "2025-10-10T03:43:19Z")

</div>

```
@classmethod

@catch

def query(cls, filter=None, fieldList=None, orderList=None, page=None, size=None):

    """

    查询多条数据

    :param filter: 筛选条件，Q表达式字符串

    :param fieldList: 筛选条件，Q表达式字符串

    :param orderList: 排序规则

    :param page: 第几页

    :param size: 每页多少条

    :return {

        "rowDatas": data, 多行数据

        "totalCount": count 总行数

    }

    """

    raise NotImplementedError

```

我希望引入arrow的库来查询dremio  
像上面的筛选条件条件，并不是标准的sql，orm有提供q表达式的转换方法吗？  
我希望将查询转换成标准sql，然后让dremio进行查询

---

<div class="post-metadata">

**Author:** ![sumu](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.jit.pro/sumu/32/31_2.png) [@sumu](https://forum.jit.pro/u/sumu)\
**Post date:** [October 10, 2025, 7:18am UTC](https://forum.jit.pro/t/topic/357/2 "2025-10-10T07:18:06Z")

</div>

@wanjianjun

---

<div class="post-metadata">

**Author:** ![wanjianjun](https://avatars.discourse-cdn.com/v4/letter/w/cab0a1/32.png) [@wanjianjun](https://forum.jit.pro/u/wanjianjun)\
**Post date:** [October 10, 2025, 8:22am UTC](https://forum.jit.pro/t/topic/357/3 "2025-10-10T08:22:11Z")

</div>

Q表达式语法参考 [Q表达式 | JitAi](https://jit.pro/zh/docs/reference/framework/JitORM/q-expressions)  
目前没有直接将Q表达式转sql，因为字段会涉及关联字段以及特殊的查询，你可以参考Q表达式语法，使用Q表达式查询或者直接拼接sql进行查询

---

<div class="post-metadata">

**Author:** ![wanjianjun](https://avatars.discourse-cdn.com/v4/letter/w/cab0a1/32.png) [@wanjianjun](https://forum.jit.pro/u/wanjianjun)\
**Post date:** [October 11, 2025, 2:07am UTC](https://forum.jit.pro/t/topic/357/4 "2025-10-11T02:07:35Z")

</div>

你的数据库如果兼容已有数据库类型，建议直接创建对应数据库元素，基于该数据库元素可以新建数据模型进行查询，如果不兼容已有的六种数据库，暂时不支持提供Q表达式转标准的sql的方法。

---

<div class="post-metadata">

**Author:** ![hww](https://avatars.discourse-cdn.com/v4/letter/h/e56c9b/32.png) [@hww](https://forum.jit.pro/u/hww)\
**Post date:** [October 11, 2025, 3:15am UTC](https://forum.jit.pro/t/topic/357/5 "2025-10-11T03:15:42Z")

</div>

我用的是dremio，那就只能自己写转换函数了