Does SQL Server support the Poisson distribution?
Yes, SQL Server does support it, as a part of Data Analysis Expressions (DAX).

The documentation for the function for getting Poisson distribution data is here.