title: SQL view with dynamic count of columns
body: <p>I know it is impossible directly, but maybe with help of sql functions it is possible to create view with dynamic column count? What exactly I want to do is - Create view which's columns would be username (first table's values), date (second table's values), and multiple columns for properties (each third table's row would be column).User table structure - ID and username, Date table structure - ID and datetime, Property table structure - ID, property name, property value, fk user ID (plus one table to relate tables). 
  Result should look something like that (columns):</p>
  
  <p>|username| date | property 1|....|property n|</p>
  
  <p>Can anyone could show any simple sample ?</p>