[FEATURE]: MSSQL dialect

[AlexBlokh]

Describe want to want

Implement support for MSSQL dialect and popular drivers

[JeffEmery]

I’m not smart enough to talk about this in depth, but Dapper seems like a good place to start.

Table Valued Types / Parameters too

[walleXD]

Would the implementation leverage tedious under the hood?

[Irupt]

Tedious would be a perfect start

[Farmacist-Dylan]

Anyone know where this sits on the priority list?

[ic-dominic]

I'm also wondering since we use SQL Server for almost every database at our company and using this ORM for it would be awesome

[janusqa]

This is the killer app for drizzle. Letsssss goooooooooo!!!!11!2

[v1d3rm3]

In my company, we use only SQL Server.

[AlexBlokh]

@JeffEmery @walleXD we will definitely support all industry standard drivers @Farmacist-Dylan we are aiming to cover it mid autumn

@ic-dominic @v1d3rm3 we're doing our best to cover all developers needs and are currently a bit overwhelmed if your company can benefit from Drizzle - feel free to contribute financially and we'll gladly prioritise MsSQL

[v1d3rm3]

Unfortunately, it's a public company. But i'll start contributing from now.

[janusqa]

@AlexBlokh are the contributions done thru the sponsors here? https://github.com/sponsors/drizzle-team

[AlexBlokh]

@janusqa yes, we have stripe links too, if it's more convenient

[WilliamWelsh]

This feature will solve my woes

[tyleralbee]

Any update on this? I realize the PR is under review, hoping to see it merged.

[ssch-99]

pls release it🚀

[rdrigos]

When will MSSQL support be available in Drizzle Orm? I need it urgently, this would solve problems I have with Prisma

[WilliamWelsh]

me using my mind powers to merge this pr

[jpsala]

Do you know if this will be ready soon? In my work, they only use Azure/MSSQL 😒

[itpropro]

Any updates on this? MSSQL support would really help, especially bigger companies use it a lot.

[Kysawier]

Yo, it would be very cool to be able to use drizzle with mssql, especially since it's one of the most used db in corporations

[opensas]

do we have some estimated timeline for this? any possibility for this year?

[GustavoOS]

do we have some estimated timeline for this? any possibility for this year?

Probably yes https://github.com/drizzle-team/drizzle-orm/discussions/2450#discussioncomment-10491262

[itpropro]

do we have some estimated timeline for this? any possibility for this year?

Probably yes #2450 (comment)

There is no timeline about MSSQL in that issue, it is about PostgreSQL RLS, although that issue was a dependency for MSSQL. I would assume the timeline is Drizzle ORM V1 according to the official roadmap:

[Aaqu]

Czy mamy jakiś przybliżony harmonogram tego procesu? Czy jest jakaś możliwość na ten rok?

Prawdopodobnie tak #2450 (komentarz)

W tym problemie nie ma osi czasu dotyczącej MSSQL, chodzi o PostgreSQL RLS, chociaż ten problem był zależnością dla MSSQL. Zakładam, że oś czasu to Drizzle ORM V1 zgodnie z oficjalną mapą drogową:

https://github.com/drizzle-team/drizzle-orm/pull/1610#issuecomment-2264730961

[itpropro]

Czy mamy jakiś przybliżony harmonogram tego procesu? Czy jest jakaś możliwość na ten rok?

Prawdopodobnie tak #2450 (komentarz)

W tym problemie nie ma osi czasu dotyczącej MSSQL, chodzi o PostgreSQL RLS, chociaż ten problem był zależnością dla MSSQL. Zakładam, że oś czasu to Drizzle ORM V1 zgodnie z oficjalną mapą drogową:

#1610 (comment)

There are no news on MSSQL in Discord or the issues. This is Postgres related.

[farhan-helmy]

I just joined this company and they are using MSSQL, cant wait for this to be released!