Even without aliases, I still prefer PowerShell on Windows. Once you've turned the text into an object, you can pipeline it to hell.
Get-Content .\example.csv | ConvertFrom-Csv | Where-Object -Property color -eq red
30 karma · joined September 25, 2013
Get-Content .\example.csv | ConvertFrom-Csv | Where-Object -Property color -eq red
Nothing when it's going shit ;)