Rick Drizin

Hi @smddzcy . That should be an easy change: check out how we're doing for the Parameters Prefix to allow other databases (e.g. Oracle) and you can do something similar...

Actually I think I need more context here. Basically our library just pass the arrays to Dapper so it should expand exactly like Dapper do. We don't add any parentheses...

@smddzcy I created a [MariaDB database](https://github.com/Drizin/DapperQueryBuilder/blob/master/src/DapperQueryBuilder.Tests/Setup-MySQL.sql) and a [unit test for array expansion in MariaDB/MySQL](https://github.com/Drizin/DapperQueryBuilder/blob/master/src/DapperQueryBuilder.Tests/MySQLTests.cs#L59): **It seems to be working fine.** When Dapper [PackListParameters](https://github.com/DapperLib/Dapper/blob/main/Dapper/SqlMapper.cs#L2020) is invoked it adds the parentheses...

Like this? ```cs public enum AuthorsEnum { Kafka = 1, MachadoDeAssis = 2, } [Test] public void TestNullableEnumArrays() { AuthorsEnum[]? authorIds = new AuthorsEnum[] { AuthorsEnum.Kafka, AuthorsEnum.MachadoDeAssis }; var authors...

I'm afraid you'll have to provide more details here. Either you can share a minimal reproducible example (where I can just paste and reproduce your error) or you'll have to...

@smddzcy By the lack of response I'm assuming it's working, so I'm closing this. Please reopen (with more details) if it's not working.

@ryburn52 C# compiler doesn't provide the names of interpolated variables, so you'd have to provide them as `format` or wrap under an `anonymous object` or some other type. As reference...

Not sure if I understood what you want, but have you checked the [`:raw`](https://github.com/Drizin/DapperQueryBuilder/#raw-strings) modifier? You should be able to do something like: `query.AppendLine($"Select * from {nameof(Users):raw} Where {nameof(Users.ModifiedDate):raw}>= {asOfDate:@asOfDate}");`...

I feel that we should be supporting custom TypeHandlers. Reopening in case someone volunteers to add support for that.

Since this seems to be abandoned, I've [cloned](https://github.com/Drizin/journey/) the original repo and the wiki, picked some updates (looks like the build is working fine now), and I've enabled the issues...