I copy pasted your code and made some modifications to it and I get this error:
line 2, in transform TypeError:'..........................." Object is not iterable
return [dict(row, **{'style': {'color': "green" if row['value'] == "Old" else "red" }}) for row in value]
I really want this to work because I don't want to rely on hard code, here is something I tried, with the help of the great amazing community, that worked for me.
from copy import deepcopy
if self.getSibling("TextField_Asset").props.text is not None and len(self.getSibling("TextField_Asset").props.text) > 3:
txt = "%" + self.getSibling("TextField_Asset").props.text + "%" # CREATING LIKE PARAMETER %userinput%
self.custom.custpro = txt
query = "SELECT Val1 as Asset, Val2 as Sheet, Val3 as Title, Rev, Status, Path, Val6 as Vendor, Val7 as Category, FileNameModified, ID FROM ProductionData.dbo.DrawingInfo WHERE Val1 LIKE ? AND DocType = 2 ORDER BY Val2, rev DESC"
newData = [] # EMPTY LIST FOR DATASET
results = system.db.runPrepQuery(query, [txt]) # RUNNING QUERY
stylesDict = {'Old' : {'backgroundColor': '#00FF00', 'color': '#FF0000'}, 'Current' : {'backgroundColor': '#FFFFFF', 'color': '#00FF00'}}
colNames = results.columnNames
# Create a blank version of newRow.
blankRow = {col : {'value': None, 'style' : {}} for col in colNames}
for row in results:
newRow = deepcopy(blankRow)
for col in colNames:
newRow[col]['value'] = row[col]
if col == 'Status':
newRow[col]['style'] = stylesDict[row[col]]
newData.append(newRow)
self.getSibling("Table").props.data = newData
That was days in the making 
.
Here is what it looks like, and aditonally I can add more to the styledict right? I can define column widths, text alignment, etc?
