This paper proposes a query abstraction mechanism which allows web/mobile-service administrator to formulate a skeleton of a sequence of SQL queries by parameterizing holes, later being filled by end-users. The mechanism is generic as the administrator can use it to register multiple services, and expandable as the existing service can be specialized, to automatically generate new kinds of personalized services. An end-user’s input, when given in its entirety, initiates the automatic generation of appropriate SQL queries suitable for the user’s requested service. A personalized service can be devised by designating the end-user’s input parameters into static or dynamic. When static input arguments are given, a specialized skeleton service w...