Bug 298149

Summary:	Add support for native SQL statements to Kexi
Product:	[Applications] KEXI	Reporter:	Jarosław Staniek <staniek>
Component:	Queries	Assignee:	Kexi Bugs <kexi-bugs>
Status:	CONFIRMED ---
Severity:	wishlist	CC:	adam, flight16, inksi
Priority:	NOR	Keywords:	bounty
Version:	2.4.0
Target Milestone:	---
Platform:	unspecified
OS:	All
URL:	https://github.com/staniek/kexi/issues/6
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Jarosław Staniek 2012-04-14 20:48:20 UTC

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.24) Gecko/20111101 SUSE/3.6.24-0.2.1 Firefox/3.6.24
Build Identifier: 

It would help to add support for native SQL statements to Kexi. Assuming user knows what she's doing, any SQL query, of any type, would be sent intact to the backend.

The reasoning is:

The cost would be:
- low security when transferring to other users (but we can add warning or request for confirmation globally or per-query)
- degraded back-end-independence (but this would not be issue at all for certain users)

The native query would be visually differentiated in special way, e.g. via different icon. It could be also possible to indicate type of query using some heuristics (but without 100% of certainty).

Limitations:
- Kexi's GUI expects KEXISQL-compliant queries, so any native SQL query would not be easily available to use in data grid view, form/report view, etc.

Alternative solution:
- Wait for switching to Predicate and its implementation of native database handling. Maybe it would introspect into the table schema better what would make the need explained in this wish unnecessary.

Reproducible: Always

Comment 1 Jarosław Staniek 2012-04-14 21:22:03 UTC

The reasoning is:
Kexi's built-in support for queries are limited and while will improve over time, specific features may be needed for more complex use cases.

Comment 2 flight16 2015-08-21 01:22:11 UTC

Hi Jarsoslaw, reading point two on bug 348017 comment 4, it seems like you are ok with a native SQL mode.

There are also other requests that this would satisfy while kexi-mode features are being implemented:
- Bug 141345 - Add support for JOIN in Query Designer 
- Bug 348017 - Add support for 'case insensitive' operator ILIKE for SQL queries 
- Bug 195360 - Add support for grouping and aggregation functions like sum(), count() in queries 
- Me wanting to use to use strftime() and aggregation in sqlite3.
- Probably others.

What changes are required to make a native sql mode for queries?  What is your time estimate?  If the scope isn't too large I would be interested in helping out, although I can't commit to anything right now.

Comment 3 Jarosław Staniek 2015-08-26 06:41:40 UTC

Founding possible at https://github.com/staniek/kexi/issues/6 (click Post a bounty on it)

Comment 4 Jarosław Staniek 2015-08-26 06:48:38 UTC

If you want to know the sum needed to implement it, fundraiser is at https://www.bountysource.com/teams/kexi/fundraiser