Is it possible to override some drift query building logic ?

[Bill-Hetherington]

I made a MSSQL plugin to work with drift and it works quite well. But i have one issue around drift's query building, specifically the use of limit for example:

select(dsDao.menuItemMaster)
      ..where((tbl) => tbl.menuItemMasterID.equals(masterId))
      ..limit(1);

My plugin is meant to work for sqlExpress which does not support the "limit" clause instead using "Top". So as a workaround I could manipulate the query that drift builds using string manipulation prior to sending it off to my Db.
But i'm interested to see if i could possibly override drift query building logic, as i did by making my own DatabaseDelegate, if possible without forking drift. The goal behind this plugin is to work seamlessly with drift so i would like any typical dao method like the example i provided to work with my plugin.
Any insight would be appreciated.

[simolus3]

Drift doesn't allow patching the behavior of builtin clauses like LIMIT from outside of the package.

However, I'm happy to take contributions expanding drift support for different dialects. We define a dialect enum here.

drift/drift/lib/src/runtime/query_builder/query_builder.dart

Lines 95 to 98 in 06dbcc7

	/// An enumeration of database systems supported by drift. Only
	/// [SqlDialect.sqlite] is officially supported, all others are in an
	/// experimental state at the moment.
	enum SqlDialect {

This could be expanded to include MSSQL-specific dialects, the implementation of the limit clause (query_builder/components/limit.dart) could then be changed to be aware of that option and generate the appropriate SQL.
I can't promise official support for that dialect without substantial tests, but even first and incomplete steps are welcome contributions and would make drift work with your use-case.
(also if your plugin is open source I'd love to reference it on the website for interested users)

[Bill-Hetherington]

Ok thank you, maybe in the near future you'll see a pull request for MSSQL dialect and a link to the plugin if i can open source it 😄