First about the advantages :

The only advantages of this approach (IMHO) are:
Security - malicious code has to navigate an extra layer of obscurity

Ahem... Security through obscurity isn't security...


Safe development - Once the abstraction layer is written,
developers working on higher levels are limited in the damage they can do
(can't "DROP TABLE")

You can achieve the same result without the SQL abstraction layer...
All you need is to provide a restricted API ( in your case the DB function layer)


Now about the disadvantages :

I'd just like to point out that the the Database locked to code problem
isn't bound to the architecture IMHO.
I suppose that even with this architecture
a clean coding could produce a relative database independance
(using list/hash to manage columns...)

Now to answer why, I have several guesses :

• Lack of impatience (too much abstraction here, to my mind)
• Some people think that complex means smart...
• The bad implementation syndrom :
  Or "how a good idea (database independance) could lead to an absurd implementation"
  By duplicating existing mechanisms(database independant API), and allowing some limitations that ruin the whole benefit(the column dependance problem))
  
• Megalomaniac Lead Programmer:
  You know the one who uses a lot of buzz words (and a lot of accronyms : DFL/SAL for DB functions layer and SQL abstraction layer ;-)

"Only Bad Coders Badly Code In Perl" (OBC2IP)

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.