Something that I have done a ton, is query a list of values from a database, and then convert them into a list for some form of manipulation. Maybe I need to generate a list of users, equipment, or really anything.
I have always converted my datasets into lists the following way:
myList =  for row in range(dataset.getRowCount()): myList.append(dataset.getValueAt(row, "myColumn"))
Well, today I feel dumb because I learned that you can do
myList = dataset.getColumnAsList("myColumn")
I figured I would share incase anyone has somehow missed this being a method on the dataset object like I have!