It is possible to do this, but I prefer to handle most transactions at the data layer. Handling this at the application layer leads to lots of round trips.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/