tags:

views:

64

answers:

1
Q: 

What is the best natural query language for SQL?

Hi Guys,

I am looking for simple query language for producing SQL commands...

For example:

  • Google Base Query Language (code.google.com/apis/base/docs/2.0/query-lang-spec.html)

  • CQL (Common Query Language)

  • Lucene Query Language (lucene.apache.org/java/2_3_2/queryparsersyntax.html)

Anybody could help me please?

Thanks

+1  A: 

I would always stick to the native database SQL for perfomance.

I dislike the idea that someone might change something in a generated layer that could ruin the query performance.

I realise this has certain draw backs, such as portability and that ORMs are popular these days.

Nanook  2010-01-21 11:20:45
yep... I would do this... but i would like to use this natural query langanuage for searching module... so I need kind of "english" query langauge...
 2010-01-21 11:22:32

related questions

How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset
How do I return random numbers as a column in SQL Server 2005?
SQL Text Searching, AND Ordering
How to programmatically make a Query in MS Access default to landscape when printed
SQL Query - Use Like only if no exact match exists?
SharePoint Content Query Web Part
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
How to force nolock hint for sql server logins
What table/view do you query against to select all the table names in a schema in Oracle?
SQL Query to get latest price
How can I monitor the executed sql statements on a ms SQL server 2005
SQL: Select like column from two tables
C# - SQLClient - Simplest INSERT
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
use table metadata for select statement in SQL Server?
Why are relational set-based queries better than cursors?
is it better to structure an SQL table to have a match, or return no result
SQL/Query tools?
SQL query to compare product sales by month
SQL, Auxiliary table of numbers
How do I Concatenate entire result sets in MySQL?
Multiple Updates in MySQL
Why doesn't SQL Full Text Indexing return results for words containing #?